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.