Remove numbers in a cell with an address

[Excel_Layman]

I have a list of addresses, with both street name and number together. I would like to keep only the street name.
The issue is that the number can be both in the beginning (e.g. 8, Rue du Matelas) and at the end (e.g. Kerkstraat 7).

If possible I would also like to exclude the letters when having for example different appartments in one house: (e.g. Schulstrasse 7b)

Thanks in advance!

[hemesh]

can you upload few data with all possibilities!

[Excel_Layman]

Here is a file with some possibilities
Possible Addresses.xlsx