hello,

I have a long string of characters and I want to extract only specific numbers from the string. I am very new to coding in excel, can someone please tell me how can I do it.

For example:

I have a string which says
"customer A purchased napkins, meat and a box of ice cream ( product no 3094844 7876393) "
I just want to extract the numbers which are in the paraenthesis 3094844,7876393

It might be possible that there is only one product number or more than one. and these numbers always appear in paraenthesis after word "product no".

Please someone can help, thanks in advance!