T
The Rook
I have a column of cells that contain text. At present I am able to find
cels with a spcific text string using the following formula:
=IF(ISNUMBER(SEARCH("PREP",E1036)),"PREP","")
what I am now wanting to do is find cells containing 2 would for text "PREP"
as above "BORE"
Can this be done?
cels with a spcific text string using the following formula:
=IF(ISNUMBER(SEARCH("PREP",E1036)),"PREP","")
what I am now wanting to do is find cells containing 2 would for text "PREP"
as above "BORE"
Can this be done?