How do I copy just the words in an Excel cell that contains numbe.

G

Guest

I have street address data. I want to sort based on addresses on the
streets. I think I need to somehow seperate the street number from the
street name and then sort?
 
J

Jason Morin

A1: 123 Main St.
A2: Main St.

Formula in A2:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

HTH
Jason
Atlanta, GA
 

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 to sort addresses in microsoft excel 2
Need to fill in map coordinates for addresses 2
How do I sorty by addresses, ignoring number, using street name 1
How do I do a Reverse Find/Search in Excel? 3
how do I look for duplicate house addresses in a column in Excel? 3
How do I combine two EXCEL columns? 4
How to sort an address with numbers and text in cell 2
How do I sort a column of street number/street name by the stree. 3

Top