Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you remove the numbers from a street address in EXCELL?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 wrote: |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you remove the numbers from a street address in EXCELL?
"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: |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you remove the numbers from a street address in EXCELL?
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove all text to the left of the @ in an email address | Excel Worksheet Functions | |||
how do Ii remove the grey page numbers in a work sheet | Excel Discussion (Misc queries) | |||
How do I remove decimals of IP address in excel? | Excel Discussion (Misc queries) | |||
how to remove separators from numbers | Excel Discussion (Misc queries) | |||
Remove Email address header | Excel Discussion (Misc queries) |