Split Data In Cell

[SmithStanley1212]

I had users input data, and some input last name, first name while others input first name last name. I was trying to write a formula that would if the cell contains a comma, grab the right of the comma, then the left, but if the cell does not contain a comma then just grab the cell value. I think I am close with what I have below, but it is not doing exactly what I am after

Please Login or Register  to view this content.

And here is sample data and desired output
Current Format Desired Format
Jones, Jackie Jackie Jones
Bob Hornclaw Bob Hornclaw
jackson, jim jim jackson

[popipipo]

If the format is not the same in each row, you should always make corrections by hand

[SmithStanley1212]

If the format is not the same in each row, you should always make corrections by hand

then is there a quick way for me to only account for the cells that are in the format of jones, jackie - or the cells that have a comma, and I ignore the rest?

[CK76]

Something like below?

Please Login or Register  to view this content.

[SmithStanley1212]

Something like below?

Please Login or Register  to view this content.

Yes that is it, perfectly! Thank you so much!

[popipipo]

Take a look at this