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

Alan P

"anandat" wrote in message
...

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

Thanks in advnace.
Anand


--
anandat
------------------------------------------------------------------------
anandat's Profile:
http://www.excelforum.com/member.php...o&userid=16878
View this thread: http://www.excelforum.com/showthread...hreadid=320558