It sort of works

So just to understand what has been done and hopefully rectify the last column which won't copy along....

Row 1 gives
A1 87261 WIMBLEDON 10:08 10:10
B1 87261
C1 WIMBLEDON
D1 10:08
E1


TRIM - Removed the spaces either side of the individual word
(so tidied up what the code found)

MID - Locates a start point (in this case the point being " " (space))

SUBSTITUTE - Hmmm Not sure what part this plays?

REPT - Repeats a section.... so tells MID to continue until a space comes along??? - Does the 100 indicate a max of 100 digits?

COLUMNS - I am totally lost by this point?


Sorry to be pain!!!


BTW PPC doesen't apear to have Text to Columns but all of the above functions are available. L.