How do I find and replace text in an Excel column?

Find and Replace works across the entire sheet or just within a selected range.

Replacing in a Column

1. Select the column (click the column letter)
2. Press Ctrl+H
3. In Find what, enter the text to search for
4. In Replace with, enter the new text
5. Click Replace All

Useful Options (click 'Options')

• Match case — distinguish uppercase from lowercase
• Match entire cell contents — find exact matches, not partial
• Within: Workbook — search across all sheets

Using Wildcards

• * — any number of characters
• ? — any single character

Example: Report* finds "Report 2023", "Report Q1", etc.

Replacing with Nothing

To delete text, leave the 'Replace with' field empty.