Split Data In Cell

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

=IFERROR(LEFT(A2, FIND(",", A2, 1)), A2)

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

Originally Posted by popipipo

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?

Originally Posted by CK76

Something like below?

=IF(ISNUMBER(FIND(",",A2)),TRIM(RIGHT(A2,LEN(A2)-FIND(",",A2)))&" " & LEFT(A2,FIND(",",A2)-1),A2)

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