Typing in all CAPS is considered bad netiqutte. SHOUTING!
try this idea
=IF(ISERR(FIND("M",A14)),1,2)

--
Don Guillett
SalesAid Software

"chesty" wrote in message
...
1MLIBGB.

CAN I USE AN IF STATEMENT FOR THE ABOVE WORD THAT TAKES INTO ACCOUNT THE 1
AND THE M

IE THE 1 AND M CHANGES CAN I CAPTURE THIS USING AN IF STATEMENT?--
chesty