Partial cell match
Posted by Rory on July 27, 2001 6:48 AM
I have a colunm containing numeric characters + 1 letter and 1 letter + numeric - is there an if statement that could match the letter? e.g. a1=200B, if a1 has a B in it then .....
Thankyou
Rory
Posted by Aladin Akyurek on July 27, 2001 7:12 AM
=IF(ISNUMBER(SEARCH("B",A1)),...),
The case-sensitive version requires FIND (instead of SEARCH).
Aladin
Posted by Rory on July 27, 2001 4:59 PM
TVM
RORY
