Hi - could you please assist with separating the data from the size column to create two or three new columns depending on the data in the size column - I can't filgure out what formula to use. thanks in advance
Size New Column1 new Column2
ADULT-L Adult L
ADULT-M Adult M
ADULT-S Adult S
ADULTLG Adult LG
ADULTMED Adult Med
10.0M 10.0 M
2.5M 2.5 M
Last edited by cinco5; 10-10-2012 at 04:20 PM. Reason: adding attachment
See if the attached works for you..
Life's a spreadsheet, Excel!
Say thanks, Click *
This is perfect - thanks - I can apply the formula to the 5K rows of data and manipulate it accordingly.... Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks