Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Separate Numbers From Text

  1. #1
    Join Date
    3rd May 2007
    Posts
    191

    Separate Numbers From Text

    Suppose I have SPSS/HR/AF00093, and I want to take from right just 00093, how it is possible???
    I want to do this in excel sheet...

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,714

  3. #3
    Join Date
    19th July 2004
    Location
    Tokyo, Japan
    Posts
    8,481

    Re: Separate Numbers From Text

    also an UDF
    =tanha(A1)
    VB:
    Function tanha(txt As String) As String 
        With CreateObject("VBScript.RegExp") 
            .Pattern = "-?\d+" 
            tanha = .execute(txt)(0) 
        End With 
    End Function 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th March 2007
    Location
    Northern Beaches, Sydney
    Posts
    76

    Re: Separate Numbers From Text

    Hi there,

    Assuming that you will always want to get the last 5 characters, and assuming that your value is in A1, use this in B1:

    =RIGHT(A1,5)

    Where 5 is the number of characters you want to display.

    Cheers,
    Averil
    -------------
    Averil Pretty

  5. #5
    Join Date
    3rd May 2007
    Posts
    191

    Re: Separate Numbers From Text

    Quote Originally Posted by jindon
    also an UDF
    =tanha(A1)
    VB:
    Function tanha(txt As String) As String 
        With CreateObject("VBScript.RegExp") 
            .Pattern = "-?\d+" 
            tanha = .execute(txt)(0) 
        End With 
    End Function 
    
    
    Thanks a bunch, it is amazing...Mr. jindon, and thanks for all for replying and guiding

    Want to know how separate the right of the SPSS/AFG/HR/FA00093 into two parts 1. SPSS/AFG/HR/ 2. FA00093, I mean to separate from right while we reach the first / symbol
    Last edited by cs2007; October 28th, 2007 at 15:29.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Separate Text String With No Delimiter
    By filthymonk in forum EXCEL HELP
    Replies: 8
    Last Post: June 23rd, 2008, 14:57
  2. Separate Text In Cells
    By peterjackson in forum EXCEL HELP
    Replies: 4
    Last Post: June 5th, 2008, 18:17
  3. Comma In Each Cell To Separate Numbers
    By heizeer in forum EXCEL HELP
    Replies: 4
    Last Post: April 19th, 2008, 11:16
  4. Extract Separate Numbers From Letters
    By ChrisOK in forum EXCEL HELP
    Replies: 7
    Last Post: February 1st, 2007, 04:33
  5. Replies: 2
    Last Post: February 11th, 2006, 06:59

Bookmarks

Posting Permissions

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