RE: $$Excel-Macros$$ Re: How to find out rightmost space in a cell of text string with many spaces.

2012-02-17 Thread Rajan_Verma
=MATCH(1,--IF(LEFT(RIGHT(A1,ROW(1:100)),1)=" ",1),0) with CSE From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Feb/Sat/2012 04:56 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: How to find out rightmos

Re: $$Excel-Macros$$ Re: How to find out rightmost space in a cell of text string with many spaces.

2012-02-17 Thread dguillett1
We have a winner! Don Guillett SalesAid Software dguille...@gmail.com From: Haseeb Avarakkan Sent: Friday, February 17, 2012 2:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: How to find out rightmost space in a cell of text string with many spaces. Another one, =MATCH(