Extract data from cell starting from 1st number digit to end

Hi all,

I want to extract data from a cell ( text and numbers combined / streetnames etc) , but it should only extract from the first number in the textline till last character.

This, because I want to extract all the street-numbers and I cannot use a formula to extract the last word/combination of the cell, because of the occasional spaces involded (example: ....11B ; 11 B; 11 B-C)

See example in attachment.

Thanks!