» Create and Add a Function for Reversed Text Characters in Microsoft Excel

1. Click Alt+F11 to open Visual Basic Editor (VBE).
2. From the Insert menu, select Module (to add a module).
3. 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:

To test the function, open Paste Function (Shift+F3).

From the User Defined category, select the ReverseText function.

In the function box, select any cell that contains text.

Click OK.

Book Store:

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books

VIEW ALL BOOKS

Recommended Books:

• Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
• Microsoft Excel VBA Programming for the Absolute Beginner
• Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
• Investing for Dummies, Third Edition
• Mortgages For Dummies®
• The Financial Numbers Game: Detecting Creative Accounting Practices

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 3.46     Views: 37266

No comments have been submitted.

Click here to post comment

For Registered Users

Click here to Regiser

For Guest

Name

Comment Title

Comments