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
©¿©¬