I need a SKU Generator Made in Excel

  • Posted:
  • Proposals: 25
  • Remote
  • #1931297
  • PRE-FUNDED
  • Awarded
Md. Sabder A.
SAMUEL O.Kishori K.Hafiz MUhammad A.Demetrios L. + 20 others have already sent a proposal.
  • 8

Description

Experience Level: Intermediate
I need a SKU generator made in excel.
Which means I need acronyms automatically generated from columns of information.

When I enter a name in the name column I need to keep the first letter of the first name and first 3 letters of the last name.
Input: Kyle Goderwis
Output: KGOD
SKU so far: KGOD

When I enter a number in the image column I need that number added to the name acronym.
Input: 234
Output: _234
SKU so far: KGOD_234

When I enter a letter in the recolor column I need that letter added to the end of the number.
Input: a
Output: a
SKU so far: KGOD_234a

When I enter a letter in the recolor column I need that letter added to the end of the number.
Input: a
Output: a
SKU so far: KGOD_234a

When I enter half step in the tile column I need HS added after the number.
Input: half step
Output: _HS
SKU so far: KGOD_234a_HS

When I enter horizontal in the tile column I need HO added after the number.
Input: horizontal
Output: _HO
SKU so far: KGOD_234a_HO

When I enter yes in the original column I need ORIG added after the name acronym.
Input: yes
Output: _ORIG
SKU so far: KGOD_ORIG_234a_HO

Check out the excel sheets attached to see an example of what i want my excel sheet to do...and the information above in excel format.

If this makes sense show me an example of how you can make an acronym automatically generate using excel.

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.