Last Name, First Name extract

[Guest]

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

 

[Bob Phillips]

If exactly as described

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

 

[Guest]

Thanks Bob,

It worked fine, exactly what I needed.