How do I select cells within a column that contain a specific word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I.e. I would like to select all the cells in a column that has the word "sum".

The cells in the column can have numbers and text. Sometimes is the text
several words where the word sum can be included. The column is very long, so
I would like a way to do this automatically.

Thanks for reading my question.
 
Select the column, use edit/Find, Find what: sum; click options button,
click Find All, then Ctrl/A, then click close. They're all selected.
Bob Umlas
Excel MVP
 

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

sumproduct - find text in string 11
Split column contents (de-concantenate) 7
SUMIF with criteria "<>" & "=" 4
Using SUMIF with criteria of cell containing a specific character 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Find last column matching criteria 2
Function to seacrh for a word across multiple columns 2
How do I exclude text??? 2

Back
Top