Thanks, not what I expected it replaced the original column that had FN" "LN
with FN and the column on the Right with LN. I'll just create another
column to put the two back together again.

"JulieD" wrote in message
...
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

Hi Philippe

sorry i thought you wanted to do this ... when you said about
column B can I compare column A to B and output the difference in column
C stripping off the extra space after the FN?

is it all sorted now or do you need additional assistance.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Philippe L. Balmanno" wrote in message
...
Thanks, not what I expected it replaced the original column that had FN"
"LN with FN and the column on the Right with LN. I'll just create another
column to put the two back together again.

"JulieD" wrote in message
...
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

Got it basically I used a version of this method first replacin " " with ,
then with an out put in column A (FN) and ran it again and an output in
column B (LN) and then in column C I put every thing back together again
=B1&", "&A1.

"JulieD" wrote in message
...
Hi Philippe

sorry i thought you wanted to do this ... when you said about
column B can I compare column A to B and output the difference in
column
C stripping off the extra space after the FN?

is it all sorted now or do you need additional assistance.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Philippe L. Balmanno" wrote in message
...
Thanks, not what I expected it replaced the original column that had FN"
"LN with FN and the column on the Right with LN. I'll just create
another column to put the two back together again.

"JulieD" wrote in message
...
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