Bill

To get street name without number.

In an adjacent column enter =MID(A1,FIND(" ",A1)+1,255)

Copy down.

To get numbers without street names.

In an adjacent column enter =LEFT(A1,FIND( " ",A1)-1)

Copy down.


Gord


On Thu, 20 Jul 2006 13:37:01 -0700, BNA Bill
wrote:



"Gord Dibben" wrote:

Remove entirely or place in a cell on their own? Both

Please provide more detail and an example of your data.
original cell: 123 Oak Street to new cell: Oak Street
original cell: 123 Oak Street to new cell(s): Oak Street Cell: 123
Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP
On Thu, 20 Jul 2006 11:41:02 -0700, BNA Bill
wrote: