Function 16)
Add Function REVERSETEXT to active workbook
=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