This spits back the samething, the number?

=IF(AND(ISNUMBER(--LEFT(I2)),ISNUMBER(FIND(" ",I2))),LEFT(I2,FIND("
",I2)-1),"")


=IF(AND(ISNUMBER(--LEFT(A2)),ISNUMBER(FIND(" ",A2))),LEFT(A2,FIND("
",A2)-1),"") perhaps?
--
David Biddulph

"Curtis Stevens" wrote in message
...
If you have addresses in a field, how can you extra the number portion of
the
address & put it into a separate field/box?