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?

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?