Find a value in a cell?

  • Thread starter Thread starter andycharger
  • Start date Start date
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
 
You could highlight the column, then simply do a find
command and that would find every instance
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Convert all cells in a range to a number 1
Copying into Filtered rows 3
find text in a string 5
Cell shows the last typed text, no matter where it is typed 0
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 1
Find a row based on a word in the cell 1
Excel Typed text appears in wrong cell 0

Back
Top