Thread: LastName, FirstName covert to FirstName LastName
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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

Reply With QuoteReply With Quote