## Forum Discussion

# find text direct in formulas

Hi community,

the last few weeks I've again and again ressources errors from Excel. To find the ressouces killer I'd like to build a short list of all used formulas that shows the number of e.g. "=lookup" or "=aggregat" or others.

How can I search for a text string directly inside the formula and sum it up and not search in the cells value?

Thanks a lot in before,

Thomas

`=COUNT(SEARCH("*"&D16&"*",C5:C13))`

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021. This formula is in cell C16 in the example.

`=FORMULATEXT(B5)`

This is the formula in cell C5 which is filled down to cell C13.

- OliverScheurichGold Contributor
`=COUNT(SEARCH("*"&D16&"*",C5:C13))`

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021. This formula is in cell C16 in the example.

`=FORMULATEXT(B5)`

This is the formula in cell C5 which is filled down to cell C13.

- Icke197Copper ContributorHi there and good evening,

You made my day 😊! It works perfectly. Thanks for your prompt help.

So I can build up the worksheet completely tomorrow 👍👌.

Thanks again & have a nice evening 😊.

Thomas- Icke197Copper ContributorIs there another possibility without reserving for each formula cell another cell with the formulatext method?

Thx