Report Offensive Message

Reponse To Answer
Thanks a lot for the reply.

Your formula is working fine. However, I got assistance from another site with different formula and both working well:

=IF(ISNUMBER(SEARCH("c",RIGHT(A1,10))),"call",IF(ISNUMBER(SEARCH("p",RIGHT(A1,10))),"put",A1))
Posted by eilli
17th Oct