Help With Sorting

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

Hello,

I have a spreadsheet with address data. Need help sorting the column data
with street addresses. The problem I run into is that I need to sort by the
letter of the street name, but it actually sorts by the number of the
street. Any way around this problem?

Thanks JR
 
Maybe you could insert some columns to the right of that column and split that
column into smaller pieces:

Select the column
data|text to columns
delimited by space

If that doesn't work for you hit Edit|Undo.

(Or save the workbook before you start and then close without saving.)
 

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

Back
Top