Hi,

I am have alot of data that i am trying to analyze and I need help with a text function. I am trying to search a text string in a cell for specific values and return a specific value. An example of the text strings would be:

Oct 2011 Travel Supp
Sep 2012 Travel
Oct 2012 Travel Sup

I am trying to get a formula to search these text strings for the word "travel" and then return a value of "travel invoice". Is this possible? Any help would be greatly appreciated.