If you are searching for a word match like 'vision' uncheck 'Match entire
cell contents' and find ' vision 'FindAll... which will list down cell
references which is having a full word 'vision' in between sentences.

'with 'Match Case' checked
'Vision '

'sentences ending with vision.
' vision.'

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Sorry, it cannot work. It says: "Microsoft Office Excel cannot find the data
you're searching for." Is there any way?

"Jacob Skaria" wrote:

If you are looking for a word match within a cell then add a space at the
beginning and end
Find what: ' Vision '


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hit Ctrl+F.From Find window click on 'Options'. Make sure you check 'Match
entire cell contents' and then do the find.

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

Still no help. It still finds words containing 'vision', like division, etc.
Well, I now understand that excel does not have such a function. Anyway,
thank you for your help, Jacob Skaria.

"Jacob Skaria" wrote:

If you are searching for a word match like 'vision' uncheck 'Match entire
cell contents' and find ' vision 'FindAll... which will list down cell
references which is having a full word 'vision' in between sentences.

'with 'Match Case' checked
'Vision '

'sentences ending with vision.
' vision.'

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Sorry, it cannot work. It says: "Microsoft Office Excel cannot find the data
you're searching for." Is there any way?

"Jacob Skaria" wrote:

If you are looking for a word match within a cell then add a space at the
beginning and end
Find what: ' Vision '


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hit Ctrl+F.From Find window click on 'Options'. Make sure you check 'Match
entire cell contents' and then do the find.

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack