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

 

[HKaplan]

Try this, where example Henry, John is in cell A1

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

This assumes the field always has the format LastName+comma+blank
+FirstName

 

[Craig860]

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

 

[HKaplan]

My mistake. This should fix it:

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