» Create and Add a Function for Reversed Text Characters in Microsoft Excel
CATEGORY - Excel Importing Text Files , Custom Functions , Import and Export in VBA
VERSION - All Microsoft Excel Versions
- Click Alt+F11 to open Visual Basic Editor (VBE).
- From the Insert menu, select Module (to add a module).
- Enter the following lines of code into the module:
Function ReverseText(text) As String Dim TextLen As Integer Dim i As Integer TextLen = Len(text) For i = TextLen To 1 Step -1 ReverseText = ReverseText & Mid(text, i, 1) Next i End Function
Testing the function:
Book Store:
Recommended Books:
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Accounting the Easy Way
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Microsoft Excel 2002 Simply Visual
- Special Edition Using Microsoft Word 2002
No comments have been submitted.
