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