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))