Concatenate

N

naja

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
 
M

Mike H

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
 
S

ShaneDevenshire

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.
 
Top