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”