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

• Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
• Financial Risk Manager Handbook, Second Edition
• Excel 2002 Power Programming with VBA
• Flipping Properties: Generate Instant Cash Profits in Real Estate
• Analysis of Financial Statements
• MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 3.47     Views: 45223

No comments have been submitted.

Click here to post comment

For Registered Users

Click here to Regiser

For Guest

Name

Comment Title

Comments