Right and Left Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I am trying to convert the text in cell A2 which is LAST NAME, FIRST NAME to
convert to FIRST NAME LAST NAME - No comma. I got pretty far with the
formula below.

This is what it looks like: Tackett, Raymond
This is what I want it to look like: Raymond Tackett
This is what the formula below makes it look like: RaymondTackett,

=(RIGHT(A2,LEN(A2)-FIND(" ",A2))) & (LEFT(A2,FIND(" ",A2,1)))

Thanks,

Raymond
 
You were close... try this:

=(RIGHT(G4,LEN(G4)-FIND(" ",G4))) &" "& (LEFT(G4,FIND(",",G4,1)-1))

Good Luck
 
This did make them in the correct format but it is skipping every other cell.
Awesome job though! It is changing A2, A4, A6, etc...
 
Domenic wrote...
Try...

=RIGHT(A2,LEN(A2)-(FIND(",",A2)+1))&" "&LEFT(A2,FIND(",",A2)-1)
Click to expand...

You could dispense with the unnecessary LEN call by using MID

=MID(A2,FIND(",",A2)+2,1024)&" "&LEFT(A2,FIND(",",A2)-1)

or REPLACE

=REPLACE(A2,1,FIND(",",A2)+1,"")&" "&LEFT(A2,FIND(",",A2)-1)
 
Thanks Harlan! Much appreciated!

Harlan Grove said:
Domenic wrote...

You could dispense with the unnecessary LEN call by using MID

=MID(A2,FIND(",",A2)+2,1024)&" "&LEFT(A2,FIND(",",A2)-1)

or REPLACE

=REPLACE(A2,1,FIND(",",A2)+1,"")&" "&LEFT(A2,FIND(",",A2)-1)
Click to expand...
 
Back
Top