Text within a Cell
=--ISNUMBER(FIND("PDQ",UPPER(A1)))
"N1KO" wrote:
Hi,
I could do with either some VBA code or excel formula to find a selection of
letters (Eg. PDQ) within a cell.
The letters could be anywhere in the cell and can be of any format Eg PdQ.
I need it to return a value of 1
Cheers
|