=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?