Hi

you might like to look at data / text to column
ensure you have a couple of blank columns to the right of the names
then select your list of names
choose
data / text to columns
delimited NEXT
untick tab tick space FINISH

and you should now have the first names in one column and the last names
(without a space) in the second column.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Philippe L. Balmanno" wrote in message
...
I am looking to extract everything on the right of a " " (space) in a text
line.
I have a lit of names in the form of FN" "LN in column A.
In column B I want to extract the LN portion of column A.

I guess the next logical question would be if I extract the LN and it is
in
column B can I compare column A to B and output the difference in column
C stripping off the extra space after the FN?

TIA
Phil