Last Name, First Name extract
 

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

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

Thanks Bob,

It worked fine, exactly what I needed.

"Bob Phillips" wrote:

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