Thanks, CJ.
I found a quick way to work around - sort the column then use text to columns on the segments with the same number of spaces and it works quick.
I will try your suggestion tonight.
I have a lot more files to fix up.
__________________
Who does the Racing Form Detective like in this one?