Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

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)

Example:

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

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.