B1:
=TRIM(MID(SUBSTITUTE(TRIM($A1)," ",REPT(" ",100)),MAX((COLUMN(A1)-1)*100,1),100))
Copy over and down
B1:
=TRIM(MID(SUBSTITUTE(TRIM($A1)," ",REPT(" ",100)),MAX((COLUMN(A1)-1)*100,1),100))
Copy over and down
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks