How to split column before number interval

Hi to all, I work on a table with a lot of records with street names and numbers and intervals like this:
1134 25 DECEMBER 1200 1399
1540 25 MAYA 1100 1299
1355 25 AUGUSTO (19 MAY) 1600 2399

and I would like to split the content at the first space and then before the number interval. I used the formula =LEFT(A1,FIND(" ",A1,1)-1) and =RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) and I get a separation at the first space (and the content into two colums).I am not sure how do I split the remaining content before the number interval.
I will be very grateful if anyone can help with this!
Thanks a lot!

If you want to split at each space, it would be easier to use Data | Text-to-Columns.

Hope this helps.

Pete

Hi Pete_UK, thanks a lot for your answer! I want to split at the first space (keep the first number in a separate column) and then at the next to last space (basically keep the number intervals in a separate column).

Hi Special-K, thank you for your reply. Actually, the numbers in the intervals can vary in lenght from 2 to 4 digits as below (they always are at least two numbers):
1300 25 OLIVEDA 100 215
1634 PARAYA 2° 1000 1500
1250 CORA 901 1199
1356 MEXICO 10 99

so the criteria for separation would be really the next to last space....
if I use this =SUPPRESPACE(DROITE(SUBSTITUE(A72;" ";REPT(" ";50));50)) I get something like the last number of the interval. But it doesn't really do the job.