Search within formula

[ml]

How do I search text within a formula and not within text or value (as done
with SEARCH or FIND functions)? I want to look for a specific word within a
formula in order to display which kind of data we are showing in a data table
(table is populated with data coming from 2 different sources, ie using 2
different formulas). Thanks,

ml

 

[Peo Sjoblom]

One possible way, do edit replace and replace = with let's say r= (replace
equal sign with r=), that will give you text strings, now select and copy the
formula(s) to a new sheet as tetxt strings, for the original formul do a
reverse find and replace and replace r= with = to turn them back into
formulas. Now go to the new sheet with the text string formulas
and use search or find. Another option would be through VBA create a UDF
(user defined function) that will return the formula

http://www.mvps.org/dmcritchie/excel/formula.htm


Regards,

Peo Sjoblom