View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] richmarin@earthlink.net is offline
external usenet poster
 
Posts: 13
Default InStr function question


I am using Excel 2002

I have this problem with Instr. Imagine a cell that contains the
following text

11,22,33

If I use the following command, instr(1,activecell.Value,"2",0)

The function returns a 4.

But, what if I wanted to function to look for exactly a 2? Because 2 is
part of 22. The function found it.

Is there a better function that will help me find exactly what I am
looking for ?