|
REVERSE.TEXT Function
Returns reversed Text from a single Text or array/Range of Texts: “abcdE” becomes EDCBA”. Values that are not text are returned unchanged.
REVERSE.TEXT is a multi-threaded, non-volatile array function.
REVERSE.TEXT Syntax
REVERSE.TEXT (Text, Num_chars)
Text (required)
An expression, range or array containing one or more text-strings to be reversed
Num_chars (optional, default 0)
Num_chars gives the number of characters to be reversed.
0 means reverse all the characters.
A positive number n returns the reverse of the last n characters only.
A negative number –n returns the reverse of the first n characters only.
Example
REVERSE.TEXT(“abcDEF”)=”FEDcba”
REVERSE.TEXT(“abcDEF”,3)=”FED”
REVERSE.TEXT(“abcDEF”,-3)=”cba”
|
