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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Gord Dibben said:
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
Click to expand...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you alphabetize street addresses within a column? 1
Match Account ID from combining street names and numbers 1
Separate address numbers from street name 4
Word Create a Phone Book using MailMerge in word 2007 0
How do I sorty by addresses, ignoring number, using street name 1
Convert street address to zip code 1
how to sort addresses in microsoft excel 2
Extract street number (foreign address) 7

Back
Top