On Tue, 8 Jul 2008 00:20:42 -0400, "T. Valko" wrote:

ssuming that the cell entry is:

123 Main Street

You can test the first character to see if it's a number. If it's number
extract the number to the first space character. Otherwise, return a blank:

=IF(COUNT(--LEFT(A1)),--LEFT(A1,FIND(" ",A1)-1),"")

123 Main Street returns numeric 123

Main Street returns a blank

1st Avenue returns a #VALUE! error.
--ron