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!
Bookmarks