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.
 |  Next  |  Last
Pages: 1 2 3
Prev: See if cell value appears within a value range given by another cell.
Next: Conditional Formatting: comparing cell values