trimming help

[alex19]

in cell c87 i have a name ex
Helmoney, Jonathen
i need it to be turened into jonathen helmoney

how can i do this i tryed this however it just gives me one name

=IF(C87<>"",TRIM(RIGHT(C87,LEN(C87)-SEARCH(",",C87)-1)),"")

 

[Paddy1979]

Hi try,

=MID(A4,FIND(",",A4,1)+2,LEN(A4)-FIND(",",A4,1))&" "&MID(A4,1,FIND(",",A4,1)-1)

There maybe a shorter way but i think it should work.

Example given is with name in cell A4.

 

[VoG]

With the name in A1

=RIGHT(A1,LEN(A1)-FIND(" ",A1)) & " " & LEFT(A1,FIND(" ",A1)-2)

 

[Richard Schollar]

Excel Workbook
	A	B
1	Helmoney, Jonathen	Jonathen Helmoney
Sheet1