I have a sheet where full addresses with House numbers and street names are
in the same cell

Example: 123 Elm Street

Is there a way I can seperate the Number from the rest of the text? I need
to do this so I can write a formula that will create Whitepages phone number
search links, and their site requires the number to be seperated.

Thanks for any help!