Hi Walt

Use Text to columns on the Data menu.

Select the cells you want to split, now goto Data Text to column
Delimited Next Check Space Next In Destination enter the cell where
the first number should appear Finish

This should do it.

Regards,
Per

"Walt Moeller" skrev i meddelelsen
...
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