how to flip text from a cell

hello, would anyone know if there is a way to take a column of cells containing text formatted like...

"lastname, firstname"

and have it remove the comma and display the text in the next column of cells flipped like this...

"firstname lastname"

or do the exact reverse.

I have a large database of names that I need to convert to the same format for lookups, and I am looking to save time editing several hundered names

Hie

try the following ...

If you have a space after the comma...

=RIGHT(A1,LEN(A1)-FIND(",",A1,1)-1) & " " & LEFT(A1,FIND(",",A1,1)-1)

If you dont have a space after the comma...
=RIGHT(A2,LEN(A2)-FIND(",",A2,1)) & " " & LEFT(A2,FIND(",",A2,1)-1)

Hope that helps.

Regards
Asim

Thank you! It works perfect!

devbox (Dave)