REPLACEB

REPLACEB string old with up to num bytes starting at start replaced by new

Synopsis

REPLACEB(old,start,num,new)

Arguments

old: original text

start: starting byte position

num: number of bytes to be replaced

new: replacement string

Description

REPLACEB replaces the string of valid unicode characters starting at the byte start and ending at start+num-1 with the string new.

Note

The semantics of this function is subject to change as various applications implement it.

Microsoft Excel Compatibility

While this function is syntactically Excel compatible, the differences in the underlying text encoding will usually yield different results.

OpenDocument Format (ODF) Compatibility

While this function is OpenFormula compatible, most of its behavior is, at this time, implementation specific.

See also

MID, SEARCH, SUBSTITUTE, TRIM.