Changing name orders FROM LastName, FirstName TO FirstName LastName

[Excel N00b]

Hi gang. I searched posts and was unable to locate this question. Any help pointing me in the right direction would be greatly appreciated!

I have two client spreadsheets with an extensive number of names that I need to compare. I would like to change the name format on one spread sheet from LastName, FirstName to FirstName LastName. probably pretty self-explanatory but Smith, John to John Smith.

Is there any way to do this automatically for an entire column?

[Tony Valko]

One way...

Data Range

	A	B
1	Smith, John	John Smith
2	Wynot, Tammy	Tammy Wynot
3	Rain, Misty	Misty Rain
4	Sharpe, Edward	Edward Sharpe
5	Van Halen, Eddie	Eddie Van Halen

This formula entered in B1 and copied down:

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