Thread: Need to separate and rearrange names
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Need to separate and rearrange names
See Chip Pearson's site for rearranging multiple permutations of names.

http://www.cpearson.com/excel/FirstLast.htm


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 13:43:01 -0700, Nadine
wrote:

How do you take Last,First and change it to First Last?
Ex: Joe,John needs to be rewritten to John Doe.
Using Excel 2003 and having the formula be in a different cell than the text
it is converting so that the original text remains unchanged.

Reply With QuoteReply With Quote