IF forumla to standardise text
Try this in B1:
=IF(ISNUMBER(SEARCH("ings",A1)),"Result Ceilings",A1)
then copy down to B100.
Hope this helps.
Pete
On Oct 10, 9:55*am, GD wrote:
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?
|