Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checking for a particular string in a cell
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking for a string & No. | Excel Worksheet Functions | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Checking for the existence of a characted in a string | Excel Discussion (Misc queries) | |||
Checking cell for Number | New Users to Excel | |||
cell checking | New Users to Excel |