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>