| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
