Jim


If my query is "S5 Q3 R9 "
The macro you sent will also display, as an exact/inverted match,
results : "S5KK Q3 R9", which is not desired.

That doesn't get returned when I run it. Did you change the macro that I
posted?

"S5[+space]" is what I want it to search for, not "S5". That way it
wouldn't return S5KK because there is not a space after 5. In my
database (the "SCIT" page) there is a space after every word in every
cell, even the last word in every cell, because I anticipated that the
macro would have to search for [word]+[space].


The two lines that look like this

what:=FWhat(j) & Chr(32), _

are what add the space and it seems to work properly for me. I can send you
the workbook I used for testing if you want to look it over and see if there
is an assumption that I'm missing.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.