Prev: Sort by column, not range
Next: Access denied when running Excel from DOS prompt with runas comman
From: Erinayn on 21 Apr 2010 17:45
I have data in LAST, FIRST and used this formula...

=TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1)

Is there a way to change it from all caps to just capitalized names.

Ex.
currently - DOE, JOHN
change to - John Doe
From: Mike H on 21 Apr 2010 17:49
Hi,

Like this

=PROPER(TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Erinayn" wrote:

> I have data in LAST, FIRST and used this formula...
>
> =TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1)
>
> Is there a way to change it from all caps to just capitalized names.
>
> Ex.
> currently - DOE, JOHN
> change to - John Doe
From: Jim Thomlinson on 21 Apr 2010 17:49
Use the Proper function

=Proper(TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1))


--
HTH...

Jim Thomlinson


"Erinayn" wrote:

> I have data in LAST, FIRST and used this formula...
>
> =TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1)
>
> Is there a way to change it from all caps to just capitalized names.
>
> Ex.
> currently - DOE, JOHN
> change to - John Doe
From: Erinayn on 21 Apr 2010 17:59
Perfect awesome to both of you!!

"Jim Thomlinson" wrote:

> Use the Proper function
>
> =Proper(TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1))
>
>
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Erinayn" wrote:
>
> > I have data in LAST, FIRST and used this formula...
> >
> > =TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1)
> >
> > Is there a way to change it from all caps to just capitalized names.
> >
> > Ex.
> > currently - DOE, JOHN
> > change to - John Doe
From: T. Valko on 21 Apr 2010 22:17
Another one...

=PROPER(MID(A2&" "&A2,FIND(",",A2)+2,LEN(A2)-1))

--
Biff
Microsoft Excel MVP


"Erinayn" <Erinayn(a)discussions.microsoft.com> wrote in message
news:E1B32A12-4AE6-4747-983B-862EDFF2EF11(a)microsoft.com...
>I have data in LAST, FIRST and used this formula...
>
> =TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1)
>
> Is there a way to change it from all caps to just capitalized names.
>
> Ex.
> currently - DOE, JOHN
> change to - John Doe


 | 
Pages: 1
Prev: Sort by column, not range
Next: Access denied when running Excel from DOS prompt with runas comman