Google Sheets Replace Function | How to Use Replace | Spreadsheet Function
Use the Google Sheets REPLACE function to replace part or the entire text with different text. You have to specify the starting point from where the replacement will begin, the number of characters to be replaced, and the new text. If you know the position or the starting point of the text, then REPLACE function would be ideal to use.
If you do not want to hard-code the starting point, one of the Google Sheets functions you can use to get the starting point is FIND.
---------------------
FIND Function
Use the FIND function to get the position of the sub-string within string.
Here is the link to the video tutorial on FIND:
• Google Sheets FIND Function | Get String P...
---------------------
---------------------
SUBSTITUTE Function
If you do not know the position of the text to be replaced and
want to search and replace, then use SUBSTITUTE instead of REPLACE.
Here is the link to the video tutorial on SUBSTITUTE:
• Google Sheets SUBSTITUTE Function | Replac...
---------------------
Here is the format of the REPLACE function:
=REPLACE(text, position, length, new_text)
Start the formula with an equal-to symbol.
REPLACE is the name of the function.
text is the string that will be replaced in part or full.
position is the starting point of text replacement.
length is the number of characters to be replaced.
new_text is the string that will replace part or full of the original string.
Let's look at an example:
=REPLACE("pen and pencil", 5, 3, "or")
Here "pen and pencil" is the text to be replaced, starting at the fifth character, three is the number of characters to be replaced, and the replacement text is "or".
The Google Sheets REPLACE function will return "pen or pencil".
Here is another example:
Say you have the text "vegetables and fruits", and you want to replace "and" with nothing.
The formula with the REPLACE function for the above task is:
=REPLACE("vegetables and fruits", 12, 4, "")
REPLACE returns "vegetables fruits".
Do take a look at this video tutorial, which gives the steps to the use the Google Sheets REPLACE function with examples.
Auf dieser Seite können Sie das Online-Video Google Sheets Replace Function | How to Use Replace | Spreadsheet Function mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Software Spring 10 August 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 53,352 Mal angesehen und es wurde von 192 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
