IF forumla to standardise text
I'm looking for a formula to do the following,,
Look at column A (cells 1-100) which is populated with text, with 3 or 4
variances of the same output, e.g "ceilings" "cielings" "clings" - i'd need
the formula to take this range into account and pick up all results with
"ings" in it, and report standard result of "Result Ceilings" for each cell
in A1-A100 with any text arrangement of "ings" in it
Can this be done?
|