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:E1B32A124AE64747983B862EDFF2EF11(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 