Re: Help With Sorting

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

JR wrote:
>
> Hello,
>
> I have a spread*** 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
.