ExcelBanter - LAST, FIRST to First Last

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - LAST, FIRST to First Last (https://www.excelbanter.com/excel-discussion-misc-queries/262133-last-first-first-last.html)

Erinayn

LAST, FIRST to First Last

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

Mike H

LAST, FIRST to First Last

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

Jim Thomlinson

LAST, FIRST to First Last

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

Erinayn

LAST, FIRST to First Last

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

T. Valko

LAST, FIRST to First Last

Another one...

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

--
Biff
Microsoft Excel MVP

"Erinayn" wrote in message
...
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

All times are GMT +1. The time now is 10:17 AM.