finding a specific word without including variations of it

[nurit]

Hello All,
is there a way to find a specific word without counting in words that include it or are plurals of it.
for example:
I want to search for the word "site"
however I do not want to include in my search the word "sites" or "opposite"
help would be much appreciated!

 

[skywriter]

I typed the following into a spreadsheet and used the find box to search.
There is a box you can check that says "match entire cell contents"
This option found only cell A1 as a match it ignored "opposite" and "sites", but also ignored "site specific". That's all I can help you with, if it doesn't work hopefully someone else knows a trick or can write you some code that works for you.

Sheet2

*	A
1	site
2	opposite
3	sites
4	site specific

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Rick Rothstein]

is there a way to find a specific word without counting in words that include it or are plurals of it.
for example:
I want to search for the word "site"
however I do not want to include in my search the word "sites" or "opposite"

Is this word you are searching for in a cell all by itself, or could it be in the cell along with other text?

And exactly what do you mean by "find"... are you looking for a VB macro that selects, or maybe colors, the cell? Or something else?