REPLACEB

Description: Replaces part of a text string with a different text string based on the number of bytes you specify. This function is for use with double-byte characters.

Syntax: REPLACEB(Old_text, Start_num, Num_bytes, New_text)

Old_text is text in which you want to replace some characters.
Start_num is the position of the character in Old_text that you want to replace with New_text.
Num_bytes is the number of bytes in Old_text that you want REPLACEB to replace with New_text.
New_text is the text that will replace characters in Old_text.

Example:

In the following example, the first three double-byte characters in cell C4 are replaced with "":

REPLACEB(C4, 1, 6, "")