Replace or Replace$

<< Click to Display Table of Contents >>

Navigation:  String functions >

Replace or Replace$

Description

Returns a string in which a specified substring has been replaced with another substring.

Syntax

Replace(expression, find, replacement)

Parameters

Part

Description

expression

Required. String expression containing substring to replace.

find

Required. Substring being searched for.

replacement

Required. Replacement substring

Example

expression = "The quick brown fox"

Result = Replace(expression, "brown", "orange")

 

'returns "The quick orange fox"