---
title: "Find and replace in a Google Sheet"
author: "Phil Bainbridge"
date: 2021-04-27T11:47:29+00:00
modified: 2021-04-27T11:47:33+00:00
canonical_url: https://pulse.appsscript.info/p/2021/04/find-and-replace-in-a-google-sheet/
markdown_url: https://pulse.appsscript.info/p/2021/04/find-and-replace-in-a-google-sheet.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
  - "Video Tutorial"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2021/04/Findandreplace.png
description: "Cleanse Google Sheet data by searching for specific words in a columns and replacing them with an alternative. Colour any cell changes to highlight. This is one of many ways of performing the task simply using loops."
---

# Find and replace in a Google Sheet

![Find and replace in a Google Sheet](https://pulse.appsscript.info/files/2021/04/Findandreplace.png)

> Cleanse Google Sheet data by searching for specific words in a columns and replacing them with an alternative. Colour any cell changes to highlight. This is one of many ways of performing the task simply using loops.
> [https://www.pbainbridge.co.uk/2021/04/find-and-replace-in-google-sheet.html](https://www.pbainbridge.co.uk/2021/04/find-and-replace-in-google-sheet.html)A list of words to find and their replacement equivalent.

Source: *[The Gift of Script: Find and replace in a Google Sheet*](https://www.pbainbridge.co.uk/2021/04/find-and-replace-in-google-sheet.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/04/find-and-replace-in-a-google-sheet/](https://pulse.appsscript.info/p/2021/04/find-and-replace-in-a-google-sheet/)*