Separating Text in a Cell
I have been trying to separate the first part of the text from each cell, but it will only return the part in all caps and the next word. I only need the part in all caps with numbers, or numbers only.
This is how it is formatted.
RSASS400
Chambray Stripe Travel Pant
The formula I am using is: =LEFT(A11,SEARCH(" ",A11)-1)
Unfortunately there is a space between The all caps/number "style" and the descriptions, and I don't know how to remove it. There are over 1000 lines, and I don't want to have to remove each space.
What is the problem? What is the expected output and what are you getting with your formula? can you post a few rows of data in a spreadsheet? There may be other characters than spaces involved.
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks