VBA/Excel/Access/Word/String Functions/String Replace
Replace replaces one string with another:
<source lang="vb">
Sub ReplaceExample()
Debug.Print Replace("Say Hello if you want to", "hello", "bye") "Returns Say bye if you want to Debug.Print Replace("This gets rid of all of the spaces", " ", "") "Returns Thisgetsridofallofthespaces
End Sub
</source>