Hi, Karthik!

Thank you so much for your help! I really appreciate it.

:-)

"Karthik" wrote:

If you have the name in A1 as Last, First

Enter in Cell B1 =MID(A1,FIND(",",A1)+2,LEN(A1))
Enter in Cell C1 =MID(A1,1,FIND(",",A1)-1)

You can have all names in column A and then copy paste cells b1 and C1
till the last row containing name.

and if there is no space in the name after the "," then write this
formula in cell B1 ( C1 formula will remain unchanged)

Enter in Cell B1 =MID(A1,FIND(",",A1)+1,LEN(A1))

Thanks
Karthik Bhat
Bangalore