Hi,

I have a col which contains lot of customer names (Col A). Now I want to
give a formula in col B to check for the few characters in col A and classify.

Ex :

Col A Col B
ABC Stores Stores (I am trying to give formual in Col
B to check the Character
"Stores" in Col A. A1 contains "ABC
Stores", in this cell i
need to check
whether "stores" is
available or not if available
classify as "Stores" in
Col B.)
DEF Mal
GHI complex
JKL Stores Stores

I request anybody to help me with a solution.

-Chr