[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

REPLACE

Syntax:

REPLACE ( string-1 , start-pos , number-chars , string-2 )

Description: Produces a new string that is string-1 with number-chars characters starting at position start-pos, replaced by string-2. (REPLACE is intended for use with languages that use the single-byte character set (SBCS), whereas REPLACEB3.17.7.270) is intended for use with languages that use the double-byte character set (DBCS).)

Arguments:

Name

Type

Description

string-1

text

Designates a string.

start-pos

number

The number of the start position within string-1 from which characters in string-1 are to be replaced. The start position of the first character is 1. start-pos shall be at least 0. If start-pos is beyond the end of string-1, the result is a new string that is string-2 appended to string-1. If start-pos is within the bounds of string-1, but number-chars goes beyond the end of string-1, the characters starting at position start-pos through to the end of string-1 shall be replaced by string-2.

number-chars

number

The number of characters within string-1 that are to be replaced by the string designated by string-2.

string-2

text

Designates a string.

 

Return Type and Value: text – A copy of string-1 with replacement characters from string-2.

However, if

start-pos < 0, #VALUE! is returned.

number-chars < 0, #VALUE! is returned.

[Example:

REPLACE("abcdefghijk",3,4,"XY") results in abXYghijk
REPLACE("abcdefghijk",3,1,"12345") results in ab12345defghijk
REPLACE("abcdefghijk",15,4,"XY") results in abcdefghijkXY

end example]