Reverse text in a cell

Hi,

I'm trying to come up with formula (no VBA), which takes text from let's say cell A1 and displays it in cell B2 in reverse order (for instance aad1 in A2 will be displayed as 1daa in B2).

I know the formula for numbers, but struggling with formula for text. So far I came up with (assuming text in cell A2 is "aab") =MID(A2,LEN(A2)+1-ROW(INDIRECT("1:"&LEN(A2))),1) - when I select it and press F9 I get: ={"b";"a";"a"}, however, after confirming the formula with CSE I only get first letter b. So what I'm trying to do is to "tell" excel to convert {"b";"a";"a"} to baa, but with no success so far.

I also would like to avoid type of formula below where I add characters together (this one works for 3 characters).

=MID(A2,LEN(A2)+1-ROW(INDIRECT("1:"&LEN(A2))),1)&MID(A2,LEN(A2)+1-ROW(INDIRECT("1:"&LEN(A2)))-1,1)&MID(A2,LEN(A2)+1-ROW(INDIRECT("1:"&LEN(A2)))-2,1)

Any help would be gratefully appreciated.

Thanks

Pepe

Thanks XOR LX,

That's the answer I was afraid of. So we might only hope these kind of functions will be introduced in some of forthcoming Office version.