Separating Alpha and Numeric

[maheshmaxi]

Hi

I have data in column with combination of alpha-numeric like "Member # 308166 RCI Number 4801-60436". can I split this without using copy and paste?

Pls help me regarding...

 

[pgc01]

And another RegEx one:

Function GetNumbers(s As String)
 
With CreateObject("vbscript.regexp")
    .Global = True
    .Pattern = "\D+"
    GetNumbers = Replace(Application.Trim(.Replace(s, " ")), " ", ",")
End With
End Function

 

[skeatt]

in F4: =-LOOKUP(1,-LEFT(C4,{1,2,3,4,5,6}))

in G4: =-LOOKUP(1,-RIGHT(LEFT(D4,FIND("m",D4)-1),{1,2,3,4,5,6,7}))

Hi pgc01,

Thankyou for your solution, and I thought you would need a function to do it; who would think that those simple strings were that powerful, it is exactly the result I was after.


Cheers

 

[pgc01]

I'm glad it helped. Thanks for the feedback.