» 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:
- The Basics of Finance: Financial Tools for Non Financial Managers
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Business Plans Kit for Dummies (With CD-ROM)
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
