Search for Specific Word within workbook

Hi all, I have searched everywhere and nothing seems to work.

For example, if I have 3 cells within my spreadsheet; 'Foot'. 'Football' and 'One Foot'

I need to search for the word 'Foot', without it showing 'Football'. So the search needs to show both 'Foot' and 'One Foot'. I have tried many diff formulas and ideas but nothing seems to work! Any idea on what I can do?

Originally Posted by hassant26

... Any idea on what I can do? ...

You haven't given us any detail of what you have tried, nor indeed how you data is laid out. Basically, you can add a space to the sought item and add a space to each value that you are looking through.

Hope this helps.

Pete

Maybe try something like

Formula:

Please Login or Register  to view this content.

Yes indeed it is

Originally Posted by Pete_UK

You haven't given us any detail of what you have tried, nor indeed how you data is laid out. Basically, you can add a space to the sought item and add a space to each value that you are looking through.

Hope this helps.

Pete

it's literally just an example to simplify it. The real data is a list of treatment and diagnosis codes, with a detailed description next to each code. I need to search for individual words without it including that same word within other words, eg foot and football, but it needs to include that specific word within other phrases, eg one foot. I need it so it doesn't list the number of data that is in the workbook, but actually allows me to search that specific word.

Regarding detail of what I have tried, pretend this is a fresh question and I've tried nothing, bar the basic 'Find' and 'Match Case' and 'Match Entire Cell Contents'. The spacing thing also does not work

Originally Posted by ByteMarks

Maybe try something like

Formula:

Please Login or Register  to view this content.

This does work, however I need it to actually search for the specific word rather than Yes/No

The yellow banner at the top of the screen gives details of how to attach a sample Excel file to one of your posts. If you do that then we might get a clearer idea of what you want to achieve - for example, are you looking for a single occurrence of the word, or for the first of many, or for all of the occurrences? Which column does the data exist in, and which cell do you use to specify the word you are looking for? So many unknowns !!

Pete

Originally Posted by Pete_UK

The yellow banner at the top of the screen gives details of how to attach a sample Excel file to one of your posts. If you do that then we might get a clearer idea of what you want to achieve - for example, are you looking for a single occurrence of the word, or for the first of many, or for all of the occurrences? Which column does the data exist in, and which cell do you use to specify the word you are looking for? So many unknowns !!

Pete

Well. the information is confidential, hence the reason why I'm not attaching it in. I think I have been quite clear, but let me try give you more information. I would like all occurrences of the specific word. It exists in Column H, not sure what this information will do for you without the data. The part where you asked which cell i use to specify, not sure what you mean by this.

All in all, all I want to know is how to search for words on its own and part of a sentence, that isn't part of another word.