formulas : new function that searches text in reverse order ?

[Jérôme Bouat <jerome.bouat@wanadoo.fr>]

Hello,


For searching a text from left to right, I can use "search" and "find" text formula.

However, I didn't found a formula for searching in the reverse order (right to left).

Someone gave to me this workaround (when searching a space character) :

=LEN(A1)-FIND("|",SUBSTITUTE(A1," ","|",
     LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))

http://stackoverflow.com/questions/350264/how-can-i-perform-a-reverse-string-search-in-excel-without-using-vba


This workaround is cpu intensive.

Could you possibly add a new function for that (or a additional parameter) ?


Regards.