Sorting rows in Excel on whether they contain a specific word/string

spiros · 1 · 2715

spiros

  • Administrator
  • Hero Member
  • *****
    • Posts: 820922
    • Gender:Male
  • point d’amour
Sorting rows in Excel on whether they contain a specific word/string

Lets say you have a glossary in 2 columns (A and B) and you want to check all the cells that refer you to another headword with the string see or βλέπε or even a specific character like a parenthesis. Let's say you want to check for instances of this string on column B with all the rows that contain the given string.

1. In column C, header row (C1), enter the phrase/string/character to find.
2. In C2 enter =ISNUMBER(SEARCH(C$1; B2)) and then drag C2 all the way down (if that gives you an error try with this: =ISNUMBER(SEARCH(C$1, B2)) ).
3. If you dragged, you will see that column C cells change to TRUE or FALSE.
4. Sort on column C.
5. Go to the bottom where you will most likely find all the cells that contain the phrase/string/character.
« Last Edit: 22 Jan, 2010, 17:05:47 by spiros »


 

Search Tools