Theย Replace function searches through a input string for a substring and replaces every instance of it with a replacement string.

This is useful for standardizing alternative abbreviations and names, fixing common misspellings, changing one delimiter for another, and selectively removing particular substrings.

Usage

Replace(string, substring, replacement)

string (required)- String to be searched and modified.

substring (required)- Substring to be found and replaced.

replacement (required)- String to replace the substring.

Examples

Replace("SF County","SF","San Francisco")

  • Returns: "San Francisco County"

Replace("File Name"," ","")

  • Returns: "FileName"
  • Using an empty string as your replacement string allows you to remove every instance of the substring

\[Order Replaced\] = Replace(Replace(\[Order Manual\], "Cold Slaw", "Cole Slaw"), "Ice Tea", "Iced Tea")

  • Returns:

Related resources