Function 15)

15) Add Function ReverseText

Using the function

=ReverseText(YourString)

You can flip or reverse the text.

I use this when I have a string with several spaces and I want to pull the last item from the right side. I can REVERSE the text then FIND the SPACE character to determine the length of that last item.

This formula:       =ReverseText(“The Data Wizard”)
Would return the string:   draziW ataD ehT

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc