Under Data - Text to Columns, choose delimited. Then choose space as your
delimiter.

--
Best Regards,

Luke M
"kenppy" wrote in message
om...
The data is already loading into columns but the length of the stuff to
strip may not be predicted, how would this be treated?
thanks

says...
Another alternative if you are pasting text into Excel is to use the text
to
columns facility.

You'll find this under data - text to columns. Ask again if you need
more
help on this.