Replace

Public Function Replace(ByVal InputString As String, ByVal Find As String, ByVal Replace As String, Optional ByVal Start As Long = 1, Optional ByVal Count As Long = -1, Optional ByVal CompareMode As Long = 0) As String

Searches a string for another string and replace the occurrences.

pInputString = Replace(pInputString, vbTab, "    ") 'Replace tabs by 4-spaces.

SendDebug Replace("Hello world", "l", "**", 1, 2) 'Prints 'He****o world'

See also: