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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checking for a particular string in a cell
Hi Christopher,
You post's layout makes it very difficult to work out what you're trying to do. However, if you want to find the string 'Stores' in a cell (eg Cell A1), you could use: =FIND("Stores",A1) This will return the position of the first character in the string where 'Stores' appears, or #N/A! if it isn't found. You can then turn that into a TRUE/FALSE result via: =NOT(ISERROR(FIND("Stores",A1))) So, if you just want 'Stores' in ColB: =IF(NOT(ISERROR(FIND("Stores",A1))),"Stores","") Alternatively: =IF(ISERROR(FIND("Stores",A1)),"","Stores") HTH Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Christopher Naveen" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checking for a particular string in a cell
Hi,
Thank u very much. I am extremely sorry while typing the window was small and i cant able to type it propoerly. You gave me the exact solution for what i requested. Thanks once again. I am again facing the problem because FIND will search the strings and i think it is case sensitive. I want to search for the character "ABC Stores" in a cell and it may be caps or small it shud return a value. Pls. tell me the function which is not case sensitive. Thank u very much Waiting for ur reply. chris "macropod" wrote: Hi Christopher, You post's layout makes it very difficult to work out what you're trying to do. However, if you want to find the string 'Stores' in a cell (eg Cell A1), you could use: =FIND("Stores",A1) This will return the position of the first character in the string where 'Stores' appears, or #N/A! if it isn't found. You can then turn that into a TRUE/FALSE result via: =NOT(ISERROR(FIND("Stores",A1))) So, if you just want 'Stores' in ColB: =IF(NOT(ISERROR(FIND("Stores",A1))),"Stores","") Alternatively: =IF(ISERROR(FIND("Stores",A1)),"","Stores") HTH Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Christopher Naveen" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
checking for a particular string in a cell
Use the function SEARCH instead of FIND.
Hope this helps. Pete On Apr 15, 12:49*pm, Christopher Naveen wrote: Hi, Thank u very much. I am extremely sorry while typing the window was small and i cant able to type it propoerly. You gave me the exact solution for what i requested. Thanks once again. I am again facing the problem because FIND will search the strings and i think it is case sensitive. I want to search for the character "ABC Stores" in a cell and it may be caps or small it shud return a value. Pls. tell me the function which is not case sensitive. Thank u very much Waiting for ur reply. chris |
Reply |
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 |