Ah.. thanks for correction..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Feb/Fri/2012 08:48
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ How to find out rightmost space in a cell
of text string with many spaces
Rajan,
The formula you posted would give 1, if there is no word in the cell and
secondly if there is only one word, the result would be 1 + length of the
word, which is incorrect.
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor th
$$Excel-Macros$$ How to find out rightmost space in a cell
of text string with many spaces.
=IF(ISNUMBER(FIND(" ",A2)),1+LEN(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT("
",100)),100))),"")
Kris
--
FORUM RULES (986+ members already BANNED for violation)
=IF(ISNUMBER(FIND(" ",A2)),1+LEN(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT("
",100)),100))),"")
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Adv