How can I remove unwanted text coming before a number? For all cells in a column?

I am geocoding and the information I am working from has unwanted information in the cells.
The way the data was sourced caused the cells to be a concatenation which is difficult to work with.
Basically, I take "123 whatever st" and find the Lat/Long for this location. Thats my goal. Something I can plug into Google maps or a mapping API.

The data (single cell) looks similar to this:

Boyfriends House 123 Main St, Vancouver, BC
or
Main and Hastings 123 Main St, Vancouver, BC
or
123 main st 123 main st, Vancouver, BC

I just need the "123 main st, Vancouver, BC" for the work. The other info just stops the geocoding dead.
Removing the duplicate like in the 3rd example would be awesome, but an excellent start would be removing just the unneeded text
How can I remove the data before the numbers from a cell?

This array-entered formula will find the second number if the first one is not preceded by a space.

Formula:

Please Login or Register  to view this content.

Array formulas are not committed in the regular way. You commit by pressing and holding Ctrl + Shift as you hit Enter. You will know that it has been entered successfully when you can see curly braces {} around your formula in the formula bar. You do not type these in yourself. Excel does it for you.

Originally Posted by AlKey

Regular formula in B1 and copy down

=REPLACE(A1,1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&1/17,FIND(" ",A1)))-1,"")

Row\Col	A	B
1	Boyfriends House 123 Main St, Vancouver, BC	123 Main St, Vancouver, BC
2	Main and Hastings 123 Main St, Vancouver, BC	123 Main St, Vancouver, BC
3	123 main st 123 main st, Vancouver, BC	123 main st, Vancouver, BC

What if the first number is preceded by a space or some other text?

Wow, quick response. Thanks, that helps alot and worked perfectly.