Find and replace in Google Sheets - Step-by-Step Guide

Introduction

Find and replace helps you quickly locate specific text or numbers in your spreadsheet and change them to something else. It saves time when you need to fix mistakes or update data without doing it manually one by one.

When you want to change all instances of a misspelled word in your sheet.

When you need to update a product code that appears many times in your data.

When you want to replace old dates with new ones across your spreadsheet.

When you want to remove unwanted characters like extra spaces or symbols.

When you want to quickly find all cells containing a certain number or text.

Steps

Step 1: Click

- Edit menu

A dropdown menu opens showing editing options

Step 2: Select

- Find and replace option in the Edit menu

The Find and replace dialog box appears on the screen

Step 3: Type

- Find field in the dialog box

The text or number you want to find is entered

Step 4: Type

- Replace with field in the dialog box

The new text or number to replace the old one is entered

Step 5: Check or uncheck

- Options like 'Match case' or 'Search using regular expressions'

Search behavior is customized based on your needs

💡 Use 'Match case' to find text with exact uppercase or lowercase letters

Step 6: Click

- Replace all button

All found instances are replaced with the new text or number

Step 7: Click

- Done button

The Find and replace dialog box closes

Before vs After

Before

Sheet contains the word 'apple' in 10 cells scattered across columns A and B

After

All 10 cells now show the word 'orange' instead of 'apple'

Settings Reference

Match case

📍 Find and replace dialog box

Makes the search find only text that matches the exact uppercase or lowercase letters

Default: Unchecked

Match entire cell contents

📍 Find and replace dialog box

Finds only cells where the whole cell content matches the search text

Default: Unchecked

Search using regular expressions

📍 Find and replace dialog box

Allows advanced search patterns using special characters

Default: Unchecked

Search

📍 Find and replace dialog box

Chooses whether to search in the current sheet or all sheets in the spreadsheet

Default: This sheet

Common Mistakes

Not checking 'Match case' when you want to replace only exact uppercase or lowercase words

The tool replaces all matches regardless of case, which may change unintended text

Check 'Match case' to limit replacements to exact letter case matches

Using 'Replace all' without previewing results

You might replace text you did not intend to change, causing errors

Use 'Find' and 'Replace' buttons to review each change before replacing

Typing partial text in 'Find' but expecting whole cell matches

Partial matches replace inside cells, not whole cells, which may cause unexpected results

Check 'Match entire cell contents' if you want to replace only whole cell matches

Summary

Find and replace lets you quickly locate and change text or numbers in your spreadsheet.

You can customize search options like case sensitivity and whole cell matching.

Always review your replacements carefully to avoid unwanted changes.