We get data from differant sources. The client info (Title Name and Surname ) comes in differant forms eg:
MR A B C Good
MR ABC Good
ABC Good MR
Good ABC
Good ABC MR

I need to break the string up in the format of Title, Name and Surname, each in its own column. Waht I currently do now is to cut the Title and name and paste it into a column and then I cut the title from the second column and paste it into the 3rd column.

I normally have 6 000 entries to manipulatelike that....

Frika