Ex: say I enter the following into cell A1: "1400 jefferson" When i
select this data from a drop down list, I do not want all of the "1400
jefferson" going into the cell, rather I want just to return the number
portion of that data "1400" what formula can do this.

Thank you,
Brian