Related Topics: | ||
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, "")
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.