|Posted: December 18, 2006, 7:50 pm - IP Logged|
lottaloot I'm not sure I uderstand the question. Are you using the find function to do the search?
Are all three digits of each number in one cell? If they are then find by column and value will find each occurance and show what is immediately before and after. if the search box is in the way just drag it to another part of the screen.
if each digit is in a seperate cell this will not work. If you are using some other search method you will need to be more specific.
I believe in a previous post you said you were using 2003 version this may have functions I'm not aware of.