+ Reply to Thread
Results 1 to 3 of 3

New to advanced XL features, and need a relatively simple (I think?) formula

  1. #1
    Registered User
    Join Date
    04-24-2017
    Location
    Cleveland, Ohio
    MS-Off Ver
    15.32 MS office for Mac
    Posts
    2

    New to advanced XL features, and need a relatively simple (I think?) formula

    Hello!
    This site has been really useful in helping me learn little pieces and parts of Excel over time, but I'm struggling to apply some new learning that I need for a work-related spreadsheet.

    I'm trying to auto-generate SKUs for a small food distributor. There are only three columns relevant to this problem: B, C and D (product name, producer name and SKU, respectively).

    I want to generate a SKU that takes the first three letters of the product name; followed by three numeric characters starting with 005 and progressing by 5 until you get to a new product name; followed by a hyphen and the two alpha characters that represent the producer.

    Thus if I have four types of Apples (red, green, gold and blush) grown by Farmer Sue, the SKUs would read:
    APP005-FS
    APP010-FS
    APP015-FS
    APP020-FS

    I'm under the impression this isn't rocket science, but I'm stymied. Thanks for any assistance! Sample file attached; please ignore columns beyond D.
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,075

    Re: New to advanced XL features, and need a relatively simple (I think?) formula

    Try in D4:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-24-2017
    Location
    Cleveland, Ohio
    MS-Off Ver
    15.32 MS office for Mac
    Posts
    2

    Re: New to advanced XL features, and need a relatively simple (I think?) formula

    I'm getting an error, but it's not making sense for me when I try to trace it. But then, LEN, LEFT and MID are new for me...
    Thanks though!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. advanced features of RAND
    By drakoleon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2016, 06:33 AM
  2. cell features to appear in formula
    By RIZVI in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2016, 02:16 PM
  3. Maybe an Advanced problem, or simple.
    By Zanderist in forum Excel General
    Replies: 3
    Last Post: 10-31-2014, 11:14 AM
  4. looking for help with macro combining formula, expansion and printout features
    By edegroote in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2013, 10:53 AM
  5. Excel 2007 Simple singular Pop up features
    By CHL1959 in forum Excel General
    Replies: 0
    Last Post: 01-14-2013, 11:45 PM
  6. a formula using SUMIF or/and Lookup features
    By ExcelNewby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2007, 08:42 AM
  7. Replies: 2
    Last Post: 09-19-2007, 07:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1