Replace is used to replace all occurrences of one string in a source string with another string:

<<Replace(Address,"Ave.","Avenue")>>

“123 Long Ave., Cape Town” becomes “123 Long Avenue, Cape Town”