Searching for charcters within formula

[ExcelMonkey]

I know you can use functions to search texts strings in formulas
SEARCH, FIND etc. However is it possible to search within a formul
for information? Lets say I have a cell that says:

=165*8000

I want to be able to search for the value before the * in this cel
(i.e. 165). That is I want to be able to identify the position of th
* (i.e. its the fourth character after the = sign) and then use a Lef
function to tell me what the value is.

Can this be done without turning the formula into text? If not, how d
you turn it into text?

Thank-yo

 

[Guest]

Hi
you'll need vBA. e.g. a function that returns the formula string:
public function get_formula(rng as range)
get_formula=rng.formula
end sub