Finding and extracting

  • Thread starter Thread starter david
  • Start date Start date
D

david

A little different twist here is someone can help.
I have a long list of contact information and I need to
pull out all the entries that have a specific word in
it...like "heating". Heating isnt the first word in the
name, so it would be like "Joe's Heating and
Air", "Carolina Heating", etc. I want to be able to pull
these out of the list. Does anyone have a suggestion,
maybe even one that does not involve a macro - though I
am not opposed to macro solutions here.

Thanks.
 
You can do this simply with a helper column that will either contain nothing
(i.e., "") or the name of the shop with "heating" in the name.

List in A1; put in B1

=IF(ISNUMBER(SEARCH("heating",A1)),A1,"")

then copy B1 down as far as there are names in A.
 
Back
Top