Thread: Converting Text Format from LAST NAME, First Name to First Name La
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre[_3_] Ron Coderre[_3_] is offline
external usenet poster
  
Posts: 60
Default Converting Text Format from LAST NAME, First Name to First Name La
With
A1: The Clown, Bozo

This formula converts that text to FirstName LastName
B1: =TRIM(MID(A1&" "&A1,FIND(",",A1&" "&A1)+1,LEN(A1)))

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"Tina" wrote in message
...
I have imported data from another program and all of the names are in this
format: Last Name, First Name

How can I change to First Name Last Name???

Reply With QuoteReply With Quote