Right and Left formula

**littlefoot** · 06-20-2012, 08:27 AM

ColumnA, ColumnB
Last name, firstname
test, test1
bob, bob2

How do I get the above to show first name last name?

so far i've got:

=LEFT(A1, SEARCH(" ",A1,1))
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1,1))

how ever it is showing the comma and I don't want that.

**tom1977** · 06-20-2012, 08:35 AM

Hi try this

=LEFT(A1, SEARCH(" ",A1,1)-2)

**daddylonglegs** · 06-20-2012, 08:38 AM

For last name try

=REPLACE(A1,1,FIND(" ",A1),"")

**galvinpaddy** · 06-20-2012, 08:45 AM

=left(a2,find(" ",a2,1)-2)

**littlefoot** · 06-20-2012, 08:52 AM

Thanks to all who replied.

Galvinpaddy i've gone with yours as it works for what i'm after.

Tom1977 - it seemed to miss out the last letter the name

daddylonglegs - It brought the first name out great but the comma I was having probs with seemed to attached it to the last name.

Thanks to all who replied.
x