I need a SKU Generator Made in Excel
- or -
Post a project like this2214
$50
- Posted:
- Proposals: 22
- Remote
- #1931297
- PRE-FUNDED
- Awarded
IT Consultant |Virtual Assistant| graphics| | Website design | social media management .
Nairobi
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
♛PPH♛1 Service Provider in Development & Design IT : WordPress | Magento | Nodejs | React.js | Laravel | SEO| React Native | Flutter |
Bhavnagar
99524814670172126052211889321186392099806209896617948141788290172698815958771536547
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.
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.
Sam C.
100% (4)Projects Completed
3
Freelancers worked with
3
Projects awarded
60%
Last project
7 May 2019
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies