For number:
=LEFT(A1,FIND(" ",A1)-1)

For Street name:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))



"Walt Moeller" wrote:

I would like to separate the street number from the street name.

Currently I have a large database with one column with an address displayed
as: 108 Delmar

I would like to keep this column but would like to have the number and the
street name set up in two new columns

--
Walt Moeller