The Reverse function reverses the order of the characters inย a string.

This function is useful for making text functions that normally work forwards from the beginning of a string, such as Mid or Substring, to instead work backwards from the end of the string.

Usage

Reverse(text)

text (required)- Text or a column of text that you want to reverse.

Example

Reverse("desserts")
  • Returns โ€œstressedโ€
[Extract Area Code (Failure)] = Mid([Phone Number], 5, 3)
[Extract Area Code (Success)] = Reverse(Mid(Reverse([Phone Number]), 6, 3))


Related resources