| 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 |
Threaded Mode
