LastName, FirstName covert to FirstName LastName

[Craig860]

I have a column with names, for example:
Last Name, First Name
ie: Smith, Joe

I'd like to be able convert it to:
Joe Smith

 

[Ron de Bruin]

Use data>Text to columns

And after that use this in a new column
=B1 & " " &A1

And copy down

 

[Craig860]

It worked for the first few names but as the length of names changed down the
list, it chopped part of the names.