View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GD GD is offline
external usenet poster
 
Posts: 83
Default 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?