Hi All - wondering if someone knows how to do the following (its possible i've banged my head against a wall one too many times trying to figure this out!):

I have a column of data with a lot of garbled text:

CelebrityCruises_Indulged_728x90.swf
Celebrity_EachDay_160x600_v02_v3.jpg
Celebrity_alt_EachDay_120x600_v03.swf
CelebrityCruises_EachDay_160x600.swf

Within each of these entries is the name of the creative type (either "indulged" or "eachday"), however unfortunately the creative name isn't in a uniform position within the cell. (for instance it isn't 10 positions at the start of the text or 10 positions from the end). In a cell adjacent to each entry, i want to label the entry as either "indulged" or "eachday" so that i can pivot out information by creative type. Does anyone have any suggestions? I'm hoping there is a formula i can use within the worksheet (maybe along the lines of: =if(A2 contains "indulged", indulged,...etc)) since i have little to no expertise with VB. That said, if VB is the only way, i suppose i'll have to get a little friendlier with it.

I have access to both office 2007 and 2003.

Huge thanks for any help here!!