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