.. First, the "Doe, John" is not in a single column.
.. It is in 2 columns, like............."Doe, John".

Here's a quick sample (amended to suit your clarification above) for easy
reference:
http://www.freefilehosting.net/download/3cg7m
Switch 1st n last names if comma.xls

Source data in cols A & B, from row2 down
In C2:
=IF(ISNUMBER(SEARCH(",",A2)),B2,A2)
In D2:
=IF(ISNUMBER(SEARCH(",",A2)),LEFT(A2,SEARCH(",",A2 )-1),B2)
Select C2:D2, copy down for the desired results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark246" wrote in message
...
Thanks for the replies, but that doesn't quite work, Max.
I'm not at all familiar with Macros, so I'm concentrating on the
Function solutiion.

First, the "Doe, John" is not in a single column.
It is in 2 columns, just like the "Mary Jones".
It is in 2 columns, like............."Doe, John".

Still, I tried your function, Max, and...
it took up TWO rows. I cannot figure out why that happened.
Thus, when I copied the function down the column, every other row is
ignored.

A bit more help, please ?
Thanks.
Mark246