formula for doing Smith Jhon to Jhon Smith ?

[anandat]

Hello I want formula for changing "Smith Jhon" to "Jhon Smith" . Th
name & surname is in same column.
Can any one please advice me ?

Thanks in advnace.
Anan

 

[Alan Perkins]

Assuming the name is in cell A1, try:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)-1)

Alan P

 

[anandat]

Thanks a lot Alan. It worked lika char

 

[FatOldGit]

It's a pleasire, anandat.

Alan P.