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" 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  |