Results 1 to 4 of 4

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

  1. #1
    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.

  2. #2
    Join Date
    May 2008
    Posts
    4,834

    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.

    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

  3. #3
    Join Date
    Apr 2008
    Posts
    4,089

    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.

  4. #4
    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.

    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

Similar Threads

  1. It is possible to get reverse text Microsoft Excel
    By Indudep in forum MS Office Support
    Replies: 4
    Last Post: 25-01-2012, 05:17 PM
  2. Need help to reverse the name order in Microsoft Excel
    By Kesar in forum MS Office Support
    Replies: 3
    Last Post: 24-01-2012, 01:16 PM
  3. How to Reverse Row Order in Microsoft Excel
    By Raju Chacha in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 05:25 PM
  4. Cell text disappear in Excel
    By Sanju Baba in forum Windows Software
    Replies: 2
    Last Post: 07-01-2012, 07:05 PM
  5. How to link a text box in powerpoint to a cell in excel
    By Aarti C in forum Windows Software
    Replies: 1
    Last Post: 06-01-2012, 05:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •