Function 16)


Add Function REVERSETEXT to active workbook

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