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}")))