Thursday, February 9, 2012

Microsoft Excel forumula for text

I had a requirement where I was having an excel sheet and based on one column's data (which is a text), I had to populate another column to provide analysis.

Basically, I wanted to find keyword prjtmp and if it is found in given cell, I want to put "DONT WORRY" in the result column. Below was the formula I put in the desired cell and BOOM!!! It worked!!! :)


=IF(ISNUMBER(SEARCH("*prjtmp*",C2)),"DONT WORRY","")

No comments: