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 18:01
This works. Thanks.

"Rick Rothstein" wrote:

> Actually, if your data could be mixed (some with a space after the comma and
> some without one), then you can use this formula to handle both of those
> conditions...
>
> =TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)))
>
> --
> Rick (MVP - Excel)
>
>
>
> "Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote in message
> news:#4QZRBe0KHA.6068(a)TK2MSFTNGP04.phx.gbl...
> > 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: Bob Phillips on 1 Apr 2010 18:36
You were lucky, I was about to write to my MP <bg>

--

HTH

Bob

"Nadine" <Nadine(a)discussions.microsoft.com> wrote in message
news:3EF557DE-50AA-4EEF-807A-99972E8E60C3(a)microsoft.com...
> That was supposed to say Bob Phillips' post worked perfect.
>
> "Nadine" wrote:
>
>> This leaves lots of extra space between the two names. Gord Dibben's
>> formula
>> worked perfect. Thanks for taking a stab at it though. I appreciate it.
>>
>> "Teethless mama" wrote:
>>
>> > =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.


First  |  Prev  | 
Pages: 1 2 3
Prev: See if cell value appears within a value range given by another cell.
Next: Conditional Formatting: comparing cell values