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.
Nesta página do site você pode assistir ao vídeo on-line Google Sheets Replace Function | How to Use Replace | Spreadsheet Function duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Software Spring 10 Agosto 2020, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 53,352 vezes e gostou 192 espectadores. Boa visualização!
