+ Reply to Thread
Results 1 to 3 of 3

Split a string into parts

  1. #1
    Registered User
    Join Date
    10-31-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Split a string into parts

    I have an excel sheet with 19784 lines of various shoe styles/sizes. There is a SKU column that contains a 5 digit item name, a 2 place letter/digit for width, followed by a three digit size. Example: 00408D 100 Meaning, style 408, width D, size 10. Another Example: 50481E2105 Meaning style 5048, width E2 or EE, size 10.5. I need to separate the style, width, and size into their own columns. Is there a function or formula to dissect a cell? Please Help, any advice appreciated! Thanks!
    Last edited by FDibbins; 11-01-2013 at 11:13 AM. Reason: was told to change title

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Is there an easy way?

    Data Range
    A
    B
    C
    D
    E
    1
    50481E2105
    50481
    E
    2
    105
    2
    50481E2105
    =LEFT(A2,5)
    =MID(A2,6,1)
    =IF(LEN(A2)=10,MID(A2,7,1),"")
    =RIGHT(A2,3)
    3
    00408D100
    00408
    D
    100
    4
    00408D100
    =LEFT(A4,5)
    =MID(A4,6,1)
    =IF(LEN(A4)=10,MID(A4,7,1),"")
    =RIGHT(A4,3)
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    10-31-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Is there an easy way?

    I was able to use Text to Column function. Thanks for the help Forum Guru! For some reason it would not allow me to do =left or =right. I don't know how to mark this solved. But it has been.

+ 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. Easy one, I think?
    By johnb28 in forum Excel General
    Replies: 4
    Last Post: 05-04-2012, 01:48 AM
  2. Easy one
    By newestnewbie in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-28-2006, 06:12 AM
  3. This should be so easy...
    By Crazy in forum Excel General
    Replies: 6
    Last Post: 12-05-2005, 04:12 PM
  4. new user with easy question? not easy for me
    By speakeztruth in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-03-2005, 05:05 PM
  5. Easy for some, not for me
    By jtwhites85 in forum Excel General
    Replies: 1
    Last Post: 05-11-2005, 10:23 PM

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