Help With Sorting

[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

 

[Dave Peterson]

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.)