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