Formula Needed to Remove Customer Name

hello all,

I am doing something for work where we created an App in Microsoft Apps, there is a feed and return that flows into Excel. for user accessibility we added both the customer name and customer number. however, the feed and return only needs th customer number, is there an easy formula to remove the word from the cell? there will be thousands of lines.

for example 1234567 Cable Coffee Shop

there would be 1,000s of lines like the one above. I want to quickly be able to remove the name so the cell is just left with digits.

if anyone has a solution, it would be greatly appreciated! Thank you!