Arrow left
Back to product guides
Google Sheets Formulas

How to Use REPLACE Function in Google Sheets

In this article, you will learn how to utilize the REPLACE formula in Google Sheets. The REPLACE function is beneficial when you want to substitute a part of the text with a different text.

How to Use REPLACE formula in Google Sheets

  1. Type “=REPLACE” or navigate to the “Insert” tab (or “Functions” icon) → “Function”“TEXT”“REPLACE”.
  2. Select the text whose part you want to substitute with another text string.
  3. Define where the modification starts (“position”), how many letters (or numbers) you need to replace (“length”), and what the substitute text is (“new_text”).
  4. Press the “Enter” key.
How to insert the REPLACE function in Google Sheets

The general syntax is as follows:

=REPLACE(text, position, length, new_text)

Text: This a text or value whose part is to be replaced with the “new_text”.

Position: This must be a positive number. This number determines where the replacement starts in the “text”.

Length: This also must be a positive number. This defines how many letters will be substituted from the “position”.

New_text: This is a text that takes the place of the specific length of text determined by “text” and “position” inputs.

As you can see from the examples in the picture below, you can substitute not only letters or marks but also numbers. If you want a number as an outcome of this formula, you can use the VALUE formula. You can combine the VALUE and REPLACE functions as follows: “=VALUE(REPLACE(B5,3,3,123))”. Furthermore, you can replace the entire text as shown in the fourth example (“LF”→“LiveFlow”).

How to use the REPLACE formula in Google Sheets with examples

How do you find and replace a value?

If you need to find a value in the first place, you can use Google Sheets’ Find and Replace functions. Read this article to learn how to use them.

Is there a way to replace all functions in Google Sheets?

The Find and Replace can also allow you to search cells for a function and replace them with a different formula. Check this article to learn how to use them.

Analyze your live financial data in a snap

Are you learning this formula to build a financial KPI dashboard or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711