LastName, FirstName covert to FirstName LastName
 

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

LastName, FirstName covert to FirstName LastName
 

Use dataText to columns

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

And copy down

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Craig860" wrote in message ...
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

LastName, FirstName covert to FirstName LastName
 

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

LastName, FirstName covert to FirstName LastName
 

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


"HKaplan" wrote:

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

LastName, FirstName covert to FirstName LastName
 

My mistake. This should fix it:

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