Oops! Just realized my formulas were the same.

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

--

"PCLIVE" wrote in message
...
As long as the format of all the address a

Number, space, street name

Then you could use the following two formulas. These formulas assume that
your data begins at A1. Adjust if needed.

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

For the streen name:
=LEFT(A1,FIND(" ",A1)-1)


HTH,
Paul

--

"Walt Moeller" wrote in message
...
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