Search not pattern in regexp

Ck76 in [A1].value="Number 123 test is 444-123456"
After i use my function udf
In B1=aa(a1,"[0-9]{3}-[0-9]{6}")
Result in B1 = "Number 123 test is"

I want in B1 use my UDF =444-123456

Xlnitwit yes like this haha thank but i want ask you
If in a1= "pattern is 111-123456 and pattern 444-123456"
The first my asking after use my udf
I want i B1 = 111-123456 444-123456
Second my asking
After use udf B1=111-123456 and 444-123456
Third my asking
After use UDF
In B1= 444-123456 ,C1=111-123456
Thank before

Xlnitwit
aa = .Execute(R.Value)(0)
(0) = first pattern

How if loop aa use sub aa()

Ok thank xlnitwit
I not see your code
In your code
Set matches = .Execute(R.Value)
Store to variant matches
Use set
In array or string without use set
Can explain me
If i am looping matches use ubound stiil can do
For example for i = ( 1 to ubound(matches))

Hehe thankyou very match jindon glad see with you
I want asking again
In a1= "text pattern for 111-123456 and next pattern 444-123456"
In Want in b1= text pattern for 111-123456
I want first text in [a1] until 111-123456
Can i am yse function in b1=left(a1,right(aa(a1,"\d{3}_\d{3}")))

Then the formula should be

=aa(A1,".*?\d{3}-\d+")

Edit

Jindon hehe
I has see internet about simbol in pattern but still confuse
Can you please explain with pattern ".*?

.*? is a shortest match that follows each particular string,

e.g

.*?\d{3}-\d+ matches to 2 parts.

text pattern for 111-123456 and next pattern 444-123456

The function aa will only picks 1st match without ref named argument.

If you change the formula to

=aa($a1,".*?\d{3}-\d+",column(a1)) then fillright

You will see each match.

Jindon i has learn from google abaut pattern
T$ = last caracter result IT from text "AT in IT
a.a = result anp from anp is text

But still not understand ". *?

Match in Regular Expression is always longest match.

If the string = "abcd efg 123-444 and xyz 333-1234"

It matches to whole with the pattern ".+\d{3}-\d+"
.*? or .+? enables to match for each appearance of the pattern.

Understand?

BTW $ represents End of string so T$ only matches to T at the end of the string.

Ok thank jindon case closed
As solved

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.