How to Reverse Text in Excel without VBA
Sheikh Saadi wrote...
that's corrat... excatly like that...
Example:
Hello Abc --- * cbA olleH
is there any function or combination of funcitons?
Not generally, no. Brute force is the only thing that comes close.
With FOOBAR in cell X99, the formula
=LEFT(RIGHT(X99,1)&LEFT(RIGHT(X99,2))&LEFT(RIGHT(X 99,3))
&LEFT(RIGHT(X99,4))&LEFT(RIGHT(X99,5))&LEFT(RIGHT( X99,6))
&LEFT(RIGHT(X99,7))&LEFT(RIGHT(X99,8))&LEFT(RIGHT( X99,9))
&LEFT(RIGHT(X99,10))&LEFT(RIGHT(X99,11))&LEFT(RIGH T(X99,12))
&LEFT(RIGHT(X99,13))&LEFT(RIGHT(X99,14))&LEFT(RIGH T(X99,15))
&LEFT(RIGHT(X99,16)),LEN(X99))
returns RABOOF. You could extend this further, but it'll run up
against the formula character limit, which means you can't reliably
reverse strings longer than 50 characters or so.
|