If exactly as described
=MID(A1,FIND(", ",A1)+2,99)&" "&LEFT(A1,FIND(", ",A1)-1)
--
HTH
Bob Phillips
"Tony" wrote in message
...
Column A has names in it. The format is Last Name, Space First Name. How
do I
extract the names so they appear in the same column or another column in
this
format.
First Name space Last Name.
Thank You in advance.
Tony
|