Martin,
In your worksheet, make sure you have blank columns to the right of the
column that contains the names.
Highlight the names.
Click the "Data" menu item.
Click "Text to Columns...".
In the pup-up wizard, select the type of data as "Delimited".
Click the "Next" button.
Remove the check mark from the "Tab" Delimiter.
Place a check mark in the "Other:" Delimiter.
Click in the box to the right of "Other:'
If your data list has spaces between the names and titles, press the space
bar one time to insert a space into this box.
Click the "Next" box.
In the "Data Preview" box, youwill see how Excel will parse your data.
If this is acceptable to you, press the "Finish" button. Wherever Excel
finds one space between the data in each cell, it will spread the data into
the cells to the right of your original list.
If Buchanan Mr & Mrs T. is in cell A1, then Buchanan will remain in cell A1
Mr will be moved to cell B1
& will be moved to C1, etc, and T. will be moved to cell E1.

Hope this helps.
Dave



"Martin ©¿©¬ @mandeREMOVETHIS.plus.com" wrote:

Hi
I have a worksheet with about 300 names in a column
The names are laid out like
Adrain Mr R. or
Buchanan Mr & Mrs T.
etc etc

Is there some way to remove the titles and just leave the Surname
without have to do it a line at-a-time?

Martin
©¿©¬