– How to Find a Text String
– How to Find a Text String with Case Sensitive
– How to Find a Text String that Matches Entire Cell with Case Sensitive
To find the text that matches the whole cell (not part of the content in the cell), please follow the steps below for details:
Step 1: Click anywhere in the worksheet;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Find & Select", and select "Find" from the drop-down list;
Alternatively, please use shortcut "Ctrl+F" to bring up "Find and Replace" window.
Step 4: In the "Find and Replace" window, type the text string (or any letters or numbers) you want to find in the worksheet;
Step 5: Click "Options" in the "Find and Replace" window, then check "Match entire cell contents";
Step 6: Click "Find Next" at the bottom to find the first record; or click "Find All" to find all the cells contain the text string (or numbers).
