» 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:
No comments have been submitted.
