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

--
Message posted from http://www.ExcelForum.com

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

-----Original Message-----
I am trying to search a range of cells on a spreadsheet
for particular
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.

Andy


---
Message posted from http://www.ExcelForum.com/

.