» 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:

• Treason: Liberal Treachery from the Cold War to the War on Terrorism
• The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
• The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
• The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
• The Analysis and Use of Financial Statements
• The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 3.46     Views: 38335

No comments have been submitted.

Click here to post comment

For Registered Users

Click here to Regiser

For Guest

Name

Comment Title

Comments