Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How can I reverse the order of text on a Excel cell

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-06-2009
Member
 
Join Date: May 2009
Posts: 136
How can I reverse the order of text on a Excel cell
  

I'm running Windows Xp along with Ms Office 2003 on my system. I would like to know that how can i reverse the order of text on a Excel cell. Can any body provide me the correct solution for the above issue? Does any body knows about it? Any kind of information on the above issue would be appreciated.

Reply With Quote
  #2  
Old 06-06-2009
Member
 
Join Date: May 2008
Posts: 4,830
Re: How can I reverse the order of text on a Excel cell

You can use the following code, in order to reverse the order of text on a Excel cell.

Quote:
Dim i As Integer

Dim StrNewNum As String

Dim strOld As String

strOld = Trim(Rcell)

For i = 1 To Len(strOld)

StrNewNum = Mid(strOld, i, 1) & StrNewNum

Next i

If IsText = False Then

ReverseCell = CLng(StrNewNum)

Else

ReverseCell = StrNewNum

End If

End Function
Reply With Quote
  #3  
Old 06-06-2009
Member
 
Join Date: Apr 2008
Posts: 4,097
Re: How can I reverse the order of text on a Excel cell

In order to reverse the character order, create and add a Custom Function to the Insert Function dialog box.

1. For that you need to Press Alt+F11 in order to open the VBE.
2. Then on VBAProject, you need to select any workbook name and insert a new Module by selecting Module from the Insert menu.
3. Then on the Module sheet, you need to type the code lines.
4. Then press Alt+F11 in order to return to Excel.
5. Afterwards, select a cell and press Shift+F3 in order to open and then Insert Function dialog box.
6. Then, from the User Defined category, you need to insert the ReverseText function.
Reply With Quote
  #4  
Old 06-06-2009
Member
 
Join Date: Jan 2008
Posts: 3,758
Re: How can I reverse the order of text on a Excel cell

In order to reverse the order of text on a Excel cell, you need to use the following code on your pc.

Quote:
Function Reverse(Text as String) as String
Dim i As Integer
Dim StrNew As String
Dim strOld As String

strOld = Trim(Text)

For i = 1 To Len(strOld)
StrNew = Mid(strOld, i, 1) & StrNew
Next i

Reverse = StrNew

End Function
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How can I reverse the order of text on a Excel cell"
Thread Thread Starter Forum Replies Last Post
It is possible to get reverse text Microsoft Excel Indudep MS Office Support 4 25-01-2012 05:17 PM
Need help to reverse the name order in Microsoft Excel Kesar MS Office Support 3 24-01-2012 01:16 PM
How to Reverse Row Order in Microsoft Excel Raju Chacha MS Office Support 1 14-01-2012 05:25 PM
Cell text disappear in Excel Sanju Baba Windows Software 2 07-01-2012 07:05 PM
How to link a text box in powerpoint to a cell in excel Aarti C Windows Software 1 06-01-2012 05:17 PM


All times are GMT +5.5. The time now is 07:35 AM.