Forum Discussion

Iron Contributor

Mar 18, 2020

ISNUMBER and SEARCH Function not working

Hi All, i have used a combination of ISNUMBER and SEARCH to find if cells contains certain TEXT. From here i used this as part of an if formula. However I am having issues with the formula not fi...

Extract Text Help1 (version 1).xlsx15 KB

Formulas and Functions

Macros and VBA

office 365

calof1

Iron Contributor

Mar 18, 2020

I have found changing the cells which contained the formula to General, rather than TEXT format addressed this error

Thanks,

PeterBartholomew1
Silver Contributor
Mar 19, 2020
calof1
It can be very disconcerting when even a formula such as
= B4
will fail the evaluate!