reverse all characters in every cell of column

[contextions]

Hi can someone please tell me code to use in column B if I want Column B to be same as column A but with all the characters in reverse order?

[AliGW]

How many characters will the cells in column A have?

[alansidman]

http://excel.tips.net/T002322_Revers..._Contents.html

[contextions]

the cells contain random words so anywhere from 1 to 20 would be a good limit1

Im not sure how this macro works from the link. It doesnt make sense to me:

Please Login or Register  to view this content.

[southward]

The macro that Alan suggested can be executed on a cell with data. That data will be reversed.
I think what you want can be found here:

https://www.extendoffice.com/documen...ord-order.html

Here are the directions that it will provide.

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following macro in the Modulewindow.

Please Login or Register  to view this content.

3. And then save and close this code, go back to the worksheet, and enter this formula: =reversestr(A2) into a blank cell to put the result, see screenshot:

[alansidman]

@contextions
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)