How to separate numbers from text in a code (into a separate column)

Hi if it is similar like 4 digit number you can go with delimit function as show in the attached Excel sheet. Follow the steps in the sheet. I hope this will clarify you...

Hey sorry dear.... I wrongly updated it

Hi,

Sorry no, I should have been more clear in my example - the original code can vary, e.g:

AA1234

BBBB - 233445

AASFFHFHGH / 44326788

In each case I just need to separate all the numbers in to a separate column (not using delimited function / text to columns)

The RIGHT function wouldnt do as I cant be sure how many numbers there will be

I had same issue before and someone gave me UDF code :

Function NumberExtract(rngString As Range, Optional lngInstance As Long = 1) As Variant
Dim RegExp As Object, RegExpMatch As Object
On Error Resume Next
Set RegExp = CreateObject("vbscript.regexp")
With RegExp
.Global = True
.IgnoreCase = True
.Pattern = "[0-9]+"
End With
Set RegExpMatch = RegExp.Execute(rngString)
If lngInstance > RegExpMatch.Count Then
NumberExtract = ""
Else
NumberExtract = RegExpMatch(lngInstance - 1)
End If
Set RegExpMatch = Nothing
Set RegExp = Nothing
End Function

================

ssume string in A1, numbers to go in B1, C1 etc...

Code:

B1: =NUMBEREXTRACT($A1,COLUMNS($B1:B1))
copied across

Thanks everyone - very useful and some good options