J
Jason
Greetings,
I have a columns of data that look similar to below that I
would like to sort on.
Column A
Burger King
McDonald's
Taco Bell, KFC, Wendy's
KFC
Wendy's
Burger King, Wendy's
The problem I am having is that when I want to filter all
burger kings, I will only get those Burger Kings that are
individually in a cell and will not get those that are
part of a string. Is it possible to somehow use advanced
filter so that it will evaluate the contents of a cell and
pull based upon the criteria even if it is included in a
string of text. For example, If I were to
choose "Wendy's" from the filter, I would like to receive
the following results:
Column A
Taco Bell, KFC, Wendy's
Wendy's
Burger King, Wendy's
Thanks for your help!
Jason
I have a columns of data that look similar to below that I
would like to sort on.
Column A
Burger King
McDonald's
Taco Bell, KFC, Wendy's
KFC
Wendy's
Burger King, Wendy's
The problem I am having is that when I want to filter all
burger kings, I will only get those Burger Kings that are
individually in a cell and will not get those that are
part of a string. Is it possible to somehow use advanced
filter so that it will evaluate the contents of a cell and
pull based upon the criteria even if it is included in a
string of text. For example, If I were to
choose "Wendy's" from the filter, I would like to receive
the following results:
Column A
Taco Bell, KFC, Wendy's
Wendy's
Burger King, Wendy's
Thanks for your help!
Jason