View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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