Re: checking for a particular string in a cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <ChristopherNaveen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0A369A08-FB13-4BC7-93A7-5FCC13DF1020@xxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: "Terms" in PHP
    ... > the unsigned integer type. ... > varchar has a small overhead to store the length of the string that's ... but it only stores the data you put in it. ... > will store a single character as a 100 character string. ...
    (php.general)
  • Re: Output of a program
    ... (You'll need to deal with the '\n' character that fgets() ... the string, and with its behavior if the input line is longer than ...
    (comp.lang.c)
  • Re: Next time a telemarketer calls you.....
    ... On the other hand I've had text-message spam on cell phones, ... You have to refuse to give your phone number to ... stores unless you want to start getting calls again. ... the vast majority of the time the cashier enters whatever the ...
    (rec.music.gdead)
  • Re: Next time a telemarketer calls you.....
    ... got an unsolicited marketing or political call on my cell. ... On the other hand I've had text-message spam on cell phones, ... stores unless you want to start getting calls again. ... Yablonski's number at the Fraud and Consumer ...
    (rec.music.gdead)
  • Re: multiple formuals in a cell
    ... weeks (is there a cell which stores the date). ... > depending on who's in the top 10 and where. ...
    (microsoft.public.excel.misc)