Reverse concatenate

Hi norm01
Find the attached with the formula. If your example is in A1 then put the formula below in B1 and pull to the right.

=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",LEN($A1))),(COLUMN()-2)*LEN($A1)+1,LEN($A1)))

DonkeyOte showed me this a few months ago. What it does is takes every space in your string and substitutes it with lots of spaces. Then it takes the a mid from the string that is blown up with spaces and uses Trim to arrive at what you want.

hope this helps.