Replace

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”