REPLACEB
Replaces characters within text based on byte count
Syntax
REPLACEB(old_text, start_num, num_bytes, new_text)
Parameters
- old_text: Required. Text in which you want to replace some characters
- start_num: Required. The position of the byte in old_text
- num_bytes: Required. The number of bytes in old_text that you want to replace
- new_text: Required. The text that will replace bytes in old_text
Example
=REPLACEB("abcdef", 3, 2, "XY")