Thread: Converting Text Format from LAST NAME, First Name to First Name La
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default Converting Text Format from LAST NAME, First Name to First Name La
You can use this to swap names around:
=MID(A2,FIND(",",A2)+2,256)&" "&LEFT(A2,FIND(",",A2)-1)
Then copy, paste special- values.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tina" wrote:

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