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?