I have a column of about 500 cells that contains different strings of words
(.e. "product download", "product video", "product documentation"). I would
like to create a formula such that Excel will tell me if the the string
contains "download", "video", or "documentation" and assign a value to each
of those (i.e. if the cell contains document then Excel would assign a "d" or
"1" and if it contains "video" it will assign a "v" or "2"). Thus far I can
only use the = sign in formulas (i.e. IF=) and this allows me to consider the
all the content in the cell and not an option for "contains either." Also,
the conditional formatting does not seem to work as I need nested formulas
and do not want a color.

Thanks in advance