F
frika
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
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