Extract the first numbers from a cell

Hi,

I have 3 cells like this:

321 FERRERO ROCHER T16
3 TWIX STANDARD
1026 BUTTONS GIANT FAMILY 175G BAGS

I would like to obtain a formula to extract the first 5 numbers before a letter from each cell. So my end product should be like this:

321
3
1026

Is there a formula to do that?

Thanks,
Your help is appreciated

If all numbers are followed by a space, use this formula:

=LEFT(A1;FIND(" ";A1)-1)

instead of A1 use the cell with the numbers and text