Last Name, First Name extract

T

Tony

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
 
B

Bob Phillips

If exactly as described

=MID(A1,FIND(", ",A1)+2,99)&" "&LEFT(A1,FIND(", ",A1)-1)
 
Top