reverse letter sorting in a cell

I have specific need for text manipulating formula. Is it possible to reverse text in a cell, for example: microsoft excel to lecxe tfosorcim.
Thanks in advance...

Hi Sakinen. Welcome to the Forum. Here's a new Function you can add to your worksheet to give yourself this simple functionality:

Please Login or Register  to view this content.

(Install that in a standard module) (source)

Then just use it like so...to reverse the text in A1, put this in B1:
=REVERSE(A1)

sakinen,

If cell A1 contains:
microsoft excel

The formula/function in cell B1:
=ReverseCell(A1,TRUE)

returns:
lecxe tfosorcim



Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Adding the Macro
1. Copy the below macro, by highlighting the macro code and pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Press the keys ALT+Q to exit the Editor, and return to Excel.

Please Login or Register  to view this content.

Hello sakinen,

Since Excel 2000, there has been a built in function to do this StrReverse.

Example

Please Login or Register  to view this content.

Oh my, Leith! Great stuff. That makes a custom function ONE LINE long...hehe. Seems to work equally well for text and numerics..

Please Login or Register  to view this content.

=REVERSE(A1)

This does convert numeric values INTO strings, but if you know you're dealing with numbers, that's easy to fix, too:

=REVERSE(A1)+0

I guess it's simple enough to build the "is it a number" test into the function:

Please Login or Register  to view this content.

With this function, Reverse("100") = Reverse("10")

Please Login or Register  to view this content.

Hmm, that does open a whole can of worms. Anything I do to lead a numeric with zeros effectively converts the string BACK into text when I feed it back to the formula. SO...

Leaving the function in it's simpler form (post #5) doesn't suffer from this problem UNLESS the user decides on their own to add back in +0. So, that's probably the simplest. The user is in control of the output appearance

What do you think?

I think that Reverse is a string function that accepts a string as its argument. If Reverse(Number) doesn't return an error, Reverse(Number)=Number seems logical.

Please Login or Register  to view this content.

For example, ...?