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.
Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
true
true
true
35
false
false