in [Functions]

Prev: See if cell value appears within a value range given by another cell.
Next: Conditional Formatting: comparing cell values
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" <rick.newsNO.SPAM (a)NO.SPAMverizon.net> 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" <Nadine (a)discussions.microsoft.com> 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 <bg> -- HTH Bob "Nadine" <Nadine (a)discussions.microsoft.com> 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. |