REPLACEB functionThe 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.