Split strings based on numbers and gather scattered strings

Hello everyone
I have in column A some strings separated by numbers ..
I need to put each string which ends with number in separated row
In fact it is difficult to describe the required but I have attached a sample workbook to illustrate the desired results
Thanks advanced for help

Hi there Yasser!
My code takes advantage from RegEx so you'll need to add the referece for it. Tools -> References Find Microsoft VBScript Regular Expressions 5.5 in the list and tick the checkbox next to it. Click OK.
Here is the used code:

Please Login or Register  to view this content.

Thanks a lot Mr. Bogdan for this wonderful solution ...
It is working exactly as I need .. thanks a lot

What If I have specific string and I need to exclude from results
I mean if the cell starts with specific string so tis row to be excluded
For example my string is "Yasser" if the cell starts with this string , so this row to be excluded fro results completely
Hope this doesn't disturb you

Please Login or Register  to view this content.

Thank you for jumping in Jindon. Your code seems more accurate. Always something to learn from you.

Thanks a lot Mr. Bogdan for your great help
Thank you very much Mr. Jindon the Great Tutor for your incredible solutions in all issues
Best Regards

Sorry for disturbing you again Mr. Jindon
I have encountered in my data new point

Related to the text to be excluded .. I don't need to exclude it if the same cell has a number ..
I mean if cell has "Yasser" at the beginning of the cell only and no numbers in this cell so this would be excluded
But if "Yasser" at the beginning of the cell and the cell has number in it so this cell would NOT be excluded ...
Sorry for disturbing as my original data may encounter new instances

Originally Posted by jindon

bulina2k,

To understand most efficient pattern in Regular Expressions needs practice, and unfortunately there is almost no web site that describe in details for many situations...

Yes you are right, I'm at the dawn of the RegEx solutions, but I can say I find them fascinating. The helping site I use is https://regex101.com/

Here's another sample

That's incredible
I can't believe myself. I am in a happy dream
Really fascinating and working like charm

As for Arabic this is a very good step .. just one little point ..
Which is the string (Arabic string) to be excluded from the process unless it has a number ..

Thanks a lot Mr. Jindon for this wonderful and great code
Is it possible to use regex patterns with arrays ..as arrays as I know is faster
In original file the code works fine .. of course I changed 100 to 20000 to get all the results

Please Login or Register  to view this content.

but it took about five minutes .. at the end it is fascinating in results .
I am searching now to get it executed faster ...
Thanks again for help and if you stopped at this point I won't be disappointed as I got incredible help from you
Best and kind regards

Thanks again and again Mr. Jindon
But it seems to have the same period .. or less a little..
Don't tire yourself .. everything is ok now and I can wait four or five minutes .. Never mind about that
Thank you very much
Best and Kind Regards

I have said 20,000 not 200,000 ..
Generally I am very satisfied with the solution you provided ..which is the following code

Please Login or Register  to view this content.

And as for the string that I need to exclude I could cure it through another macro ...
Thanks a lot for great contribution in this thread