Separate Numbers From Text

[cs2007]

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

[Dave Hawley]

Extract Number From Text Strings The result cell will need a Custom Format like: 00000 to retain leading zeros.

[jindon]

also an UDF
=tanha(A1)

Function tanha(txt As String) As String 
    With CreateObject("VBScript.RegExp") 
        .Pattern = "-?\d+" 
        tanha = .execute(txt)(0) 
    End With 
End Function 

[Averilp]

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

[cs2007]

also an UDF
=tanha(A1)

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