View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Port Man Port Man is offline
external usenet poster
 
Posts: 6
Default Data Arrangement

I have text in a cell that is in the format:
LastName FirstName MiddleName (ex. Willson James Nichols).

Is there a way to switch the text to:

FirstName MiddleName LastName (ex. James Nichols Willson)?

Thanks.
--