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
REPLACEBreturns the same value asREPLACEif the input `text` has only single byte characters- This function returns text as the output. If a number is desired, try using the
VALUEfunction 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.