If your data is always of the form {number space text}

then use the formula:
=LEFT(A1,FIND(" ",A1))

This gets you everything to the left of that space.
--
Gary's Student


"Brian" wrote:

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