Here is another approach:

1. Suppose the names are in A1:A100, select them and choose Data, Text to
Columns, Delimited, Next, check Space, Next, pick a destination cell, for
this example, C1, Finish.
2. Enter the following formula in B1 and fill it down
=SUBSTITUTE(A1,LOOKUP("ZZ",1:1),"")

convert column B to values and delete the results of step 1.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JAF-In" wrote:

Hi
How can i remove a Right side word from a set of words in one column
i need to substract the last names in to another column
eg: James William Watson... In this case i need to to take" Watson to the
next column

Regards