itREVERSE

PrecisionCalc
inspector text
Do Anything with Text in Formulas

itREVERSE

Reverses text. Accepts a single text argument and reverses the order of its characters right to left.

Syntax

itREVERSE(text)

text

Required. The text for which to reverse the characters right to left.

Examples

Formula

Description

Result

=itREVERSE("abc")

Reverse the order of the characters in the text "abc"

cba

=itREVERSE(A1)

	A
1	C:\MyFolder\MyFile.xls

Reverse the order of the characters in cell A1.

slx.eliFyM\redloFyM\:C

=RIGHT(A1,FIND("\",itREVERSE(A1))-1)

	A
1	C:\MyFolder\OtherFolder\MyFile.xls

Return the filename in the path in cell A1, no matter how many levels of folders are in the path.

MyFile.xls