From: Nadine on 1 Apr 2010 18:01 This works. Thanks. "Rick Rothstein" wrote: > Actually, if your data could be mixed (some with a space after the comma and > some without one), then you can use this formula to handle both of those > conditions... > > =TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1))) > > -- > Rick (MVP - Excel) > > > > "Rick Rothstein" wrote in message > news:#4QZRBe0KHA.6068(a)TK2MSFTNGP04.phx.gbl... > > Assuming there is no space following the comma (both your examples show > > that), give this formula a try... > > > > =MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)) > > > > -- > > Rick (MVP - Excel) > > > > > > > > "Nadine" wrote in message > > news:6FF123F5-17FF-4617-9449-57419E6EC05B(a)microsoft.com... > >> How do you take Last,First and change it to First Last? > >> Ex: Joe,John needs to be rewritten to John Doe. > >> Using Excel 2003 and having the formula be in a different cell than the > >> text > >> it is converting so that the original text remains unchanged. > > > . > From: Bob Phillips on 1 Apr 2010 18:36 You were lucky, I was about to write to my MP -- HTH Bob "Nadine" wrote in message news:3EF557DE-50AA-4EEF-807A-99972E8E60C3(a)microsoft.com...> That was supposed to say Bob Phillips' post worked perfect. > > "Nadine" wrote: > >> This leaves lots of extra space between the two names. Gord Dibben's >> formula >> worked perfect. Thanks for taking a stab at it though. I appreciate it. >> >> "Teethless mama" wrote: >> >> > =MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)) >> > >> > >> > "Nadine" wrote: >> > >> > > How do you take Last,First and change it to First Last? >> > > Ex: Joe,John needs to be rewritten to John Doe. >> > > Using Excel 2003 and having the formula be in a different cell than >> > > the text >> > > it is converting so that the original text remains unchanged.