Ctrl F - searching the displayed value rather than the formula?

[Mark McInerney]

Hi All,

Thanks for taking the time to review this - appreciated.

Just wondering if there is a way to use Ctrl F to find a text string in a column that is created using formulas

 

[Fluff]

Change the Look In (under options) from Formulas to Values

 

[Mark McInerney]

Hi Fluff - Thanks again - I really should have been able for this!!! Sorry for such a daft question!! Thanks again.

 

[Fluff]

You're welcome & thanks for the feedback.

Sorry for such a daft question!!

The only daft question is the one you don't ask.