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?