Re: $$Excel-Macros$$ Formula to grab last two words from string

2012-11-19 Thread Natron
Works Perfectly, Thanks! Rajan On Monday, November 19, 2012 11:40:26 AM UTC-5, Rajan_Verma wrote: > *If words are separated by Space use this* > > *=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)*2))** * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > -- Join offici

RE: $$Excel-Macros$$ Formula to grab last two words from string

2012-11-19 Thread Rajan_Verma
If words are separated by Space use this =TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)*2)) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Natron Sent: 19 November 2012 9:43 To: e