• Home
 · 
• String Manipulation
 · 
• This function replaces every instance of a certain within a string to any character you wish. (For

This function replaces every instance of a certain within a string to any character you wish. (For

This function replaces every instance of a certain within a string to any character you wish. (For example, change all the F's to T's in

Rate This function replaces every instance of a certain within a string to any character you wish. (For

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

    ReplaceString = ""
    For i = 1 To Len(StringToUse)
        If Mid(StringToUse, i, 1) = CharacterToSearch Then
            ReplaceString = ReplaceString & ReplacementCharacter
        Else
            ReplaceString = ReplaceString & Mid(StringToUse, i, 1)
        End If
    Next i
End Function