Syntax 

Replace[$](S$, Pat$, Rep$, [Index], [Count])


Group 

String 


Description 

Replace Pat$ with Rep$ in S$.


Parameters

Description

S$ 

This string value is searched. Replacements are made in the string returned by Replace.

Pat$ 

This string value is the pattern to look for.

Rep$ 

This string value is the replacement.

Index 

This numeric value is the starting index in S$. Replace(S,Pat,Rep,N) is equivalent to Replace(Mid(S,N),Pat,Rep). If this is omitted use 1.

Count 

This numeric value is the maximum number of replacements that will be done. If this is omitted use -1 (which means replace all occurrences).


See Also 

InStr( ), InStrRev( ), Left$( ), Len( ), Mid$( ), Right$( )


Example

Sub Main

    Debug.Print Replace$("abcabc","b","B")    '"aBcaBc"

    Debug.Print Replace$("abcabc","b","B",,1) '"aBcabc"

    Debug.Print Replace$("abcabc","b","B",3)  '"caBc"

    Debug.Print Replace$("abcabc","b","B",9)  '""

End Sub