Replace one specified string with another
Function:
Substitute(table = string, cols = list, search_for = string, replace_with = string)
Parameters:
Table: Table name on which to perform function
Columns: Range of columns to perform Substitute
Search For: Value(s) to find that is to be replaced/substituted
Replace With: Value that will replace searched for value(s)
Examples:
Substitute(table = Budget, cols = ["Geography"], search_for = "USA", replace_with = "United States")