How do you remove the numbers from a street address in EXCELL?

[Gord Dibben]

Remove entirely or place in a cell on their own?

Please provide more detail and an example of your data.


Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP

 

[BNA Bill]

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

 

[Gord Dibben]

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