Find a value in a cell?

A

andycharger

I am trying to search a range of cells on a spreadsheet for particula
words.

For example in Column K im looking for the word "Riding"

However, it could appear anywhere in the row.

e.g. "British Riding School" or "Riding School for the Blind"

Can someone tell me how I search a cell for a word?

I have a feeling its something to do with Mid$

Any help is appreciated as ever.

And
 
M

MountainBiker

You could highlight the column, then simply do a find
command and that would find every instance
 
Top