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

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
On Thu, 20 Jul 2006 11:41:02 -0700, BNA Bill <BNABill@discussions.microsoft.com>
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 <BNABill@discussions.microsoft.com>
> wrote:
>
>
>

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 <BNABill@discussions.microsoft.com>
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 <BNABill@discussions.microsoft.com>
>> wrote:
>>
>>
>>