I have a column that has last name and first name, how can i separate them so
that only the last name shows up or vice verse that the first name shows up.

thanks

Hi,

Assuming they are seperated by a space try this.

First name

=TRIM(LEFT(A1,FIND(" ",A1,1)))

Last name

=TRIM(MID(A1,FIND(" ",A1,1),LEN(A1)))

Mike


"naja" wrote:

I have a column that has last name and first name, how can i separate them so
that only the last name shows up or vice verse that the first name shows up.

thanks

Hi,

Select the names and choose Data, Text to Columns, Delimited, click Next,
check Space, click Next, in the Preview area pick the column you don't want
and then click the Skip option.
--
Cheers,
Shane Devenshire


"naja" wrote:

I have a column that has last name and first name, how can i separate them so
that only the last name shows up or vice verse that the first name shows up.

thanks

Perfect! it worked. Thanks

"naja" wrote:

I have a column that has last name and first name, how can i separate them so
that only the last name shows up or vice verse that the first name shows up.

thanks