How to Find a Text String that Matches Entire Cell Contents with Case Sensitive

– How to Find a Text String
– How to Find a Text String with Case Sensitive
– How to Find a Text String that Matches the Entire Cell Contents

To find the text that matches the whole cell (not part of the content in the cell) with case sensitive, 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 case" and "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).