Good Day all
struggling this issue for a couple of hours....
It a rather small issue but could not figure out how to solve it.
In one cell I have a string such as 1.2.3.4 and i want to find if this string contains a number appear in other cell, lets say cell $A$1 = 3.
I’ve able to do it with Instr(A1,”1.2.13.4″)...OR with Search Formula, BUT
The problem is when i have a string such as: 1.2.13.4 , it "looks" on the 3 (remember...on cell $A$1) and returned 6 , as if this number is part of the string.
But i want to check if string contain 13 NOT 3.
Any help will be appreciated !!!
Posted as well on: http://www.ozgrid.com/forum/showthread.php?t=201899
and on: http://vbaf1.com/q/a/check-if-string-in-a-cell/
Shlomi
Bookmarks