SORTING ALPHA-NUMERICALLY

B

BILL WILLIAMS

I HAVE A PLOBLEM SORTING A STREET LIST. I HAVE IT IN A TABLE AS COLUMN 1. CO RD 3434 SORTS BEFORE CO RD 402. WHAT AM I DOING WRONG?
 
G

garfield-n-odie

Nothing. Word sorts alphabetically from left to right, so CO RD 3 comes
before CO RD 4, even though there are more characters after the 3. You
should be able to import your Word data into Excel, parse it, and then
sort it there... Excel can sort numerically.
 
G

Graham Mayor

Word can sort numerically also. Set the number option in the type drop down
in the sort dialog.

This will put
CO RD 402
before
CO RD 3434

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><
 
C

Carl.

Will that really work if the field contains the preceding letters? I tried
doing it myself (with cells formated as NUMBER) and I can't get it to work.
Or are you assuming the road-type designation will be in a seperate field
from the road number?

garfield-n-odie said:
Nothing. Word sorts alphabetically from left to right, so CO RD 3 comes
before CO RD 4, even though there are more characters after the 3. You
should be able to import your Word data into Excel, parse it, and then
sort it there... Excel can sort numerically.
Click to expand...
1. CO RD 3434 SORTS BEFORE CO RD 402. WHAT AM I DOING WRONG?
 
G

garfield-n-odie

Yes, I was assuming you would parse the number into a separate column in
Excel. But see Graham Mayor's reply to your post for another idea too.
 
C

Carl.

Very handy. Thanks.

Graham Mayor said:
Word can sort numerically also. Set the number option in the type drop down
in the sort dialog.

This will put
CO RD 402
before
CO RD 3434

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><
Click to expand...
 

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

SORTING ALPHA NUMERICALLY 1
Sorting data problems 2
Cannot sort a table containing text 5
Need a Word Formula That References Text Dropdown Fields and Numeric Entries 1
Mail Merge Directory Conditional Page Break 0
alpha-sort list where each entry contains more than one line 1
Drop down lists in seperate columns 5
Sorting Ascending Subgroup in a Pivot Tables - 2007 0

Top