If you want to break them all out into seperate columns...
A B C D E 1APPLE-PEANUT-EGG-BALL APPLE PEANUT EGG BALL
B2=TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",LEN($A1))),LEN($A1)*(COLUMN()-2)+1,LEN($A1)))
copied across
If you want to break them all out into seperate columns...
A B C D E 1APPLE-PEANUT-EGG-BALL APPLE PEANUT EGG BALL
B2=TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",LEN($A1))),LEN($A1)*(COLUMN()-2)+1,LEN($A1)))
copied across
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks