in [Functions]

Prev: See if cell value appears within a value range given by another cell.
Next: Conditional Formatting: comparing cell values
From: Nadine on 1 Apr 2010 16:43 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.
From: Gord Dibben on 1 Apr 2010 17:03 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 <Nadine (a)discussions.microsoft.com>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.
From: Bob Phillips on 1 Apr 2010 17:04 Try =TRIM(MID(A1,FIND(",",A1)+1,99))&" "&LEFT(A1,FIND(",",A1)-1) -- HTH Bob "Nadine" <Nadine (a)discussions.microsoft.com> wrote in message news:6FF123F5-17FF-4617-9449-57419E6EC05B (a)microsoft.com...> 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.
From: Rick Rothstein on 1 Apr 2010 17:14 Assuming there is no space following the comma (both your examples show that), give this formula a try... =MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)) -- Rick (MVP - Excel) "Nadine" <Nadine (a)discussions.microsoft.com> wrote in message news:6FF123F5-17FF-4617-9449-57419E6EC05B (a)microsoft.com...> 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.
From: Teethless mama on 1 Apr 2010 17:15
=MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)) "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. |