REPLACEB function

The REPLACEB function replaces part of a text string, based on a number of bytes, with a different text string.

Parts of a REPLACEB function

REPLACEB(text, position, num_bytes, new_text)

Part Description
text The text, a part of which will be replaced.
position The position where the replacement will begin (starting from 1).
num_bytes The number of bytes in the text to be replaced.
new_text The text which will be inserted into the original text.

Notes

  • REPLACEB returns the same value as REPLACE if the input `text` has only single byte characters
  • This function returns text as the output. If a number is desired, try using the VALUE function in conjunction with this function.

Examples

  A B C
1 Input Formula Output
2 Aeñds =REPLACEB(A2, 2, 3,"new") Anews
3 Aeñds =REPLACE(A3, 2, 3,"new") Anews
4 熊本=熊本 =REPLACEB(A4, 2, 3,"new") 熊new熊本
5 熊本=熊本 =REPLACE(A5, 2, 3,"new")  熊new本

Related functions

  • LENB: The LENB function returns the length of a string in bytes.
  • LEFTB: The LEFTB function returns the left portion of a string up to a certain number of bytes.
  • RIGHTB: The RIGHTB function returns the right portion of a string up to a certain number of bytes.
  • MIDB:The MIDB function returns a section of a string starting at a given character and up to a specified number of bytes.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
6381773094355259307
true
Search Help Center
true
true
true
true
true
35