Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-21-2022, 04:58 AM
alanterrill alanterrill is offline Sorting does not produce an alphabetical list. Windows 10 Sorting does not produce an alphabetical list. Office 2010
Novice
Sorting does not produce an alphabetical list.
 
Join Date: Nov 2022
Posts: 5
alanterrill is on a distinguished road
Default Sorting does not produce an alphabetical list.

I've got a multi page document consisting of a single column of text , relating to articles in a set of magazines. I want to produce an index, but highlighting the text and sorting by field 1 does not result in proper alphabetical sorting. For example, part of my list of items beginning with D looks like this after sorting:


Devon —Radford, Castle Lodge 65;19
Devon —Ruined church, Ivybridge 65;5
Devon —Shell House Jordans, Ilminster 68;24


Devon —Vigers Hall, Shell House, Wallabrook 62;6
Dewstow’s grottoes, Caerwent XGW 63:8
Diaries of Sanderson Miller of Radway together with his memoir of James Menteath, The
(William Hawkes)64;12
Disney, Henry Roebuck 69;12
Dodington Follies GL 71;9
Dodington Manor Summer House GL 70;9

Design for Death (B.Jones) 16;5
Design for Death (Barbara Jones) 83;15
Design for folly 77;20




So it goes Dev to Dew, then Dia, Dod and back to Des. Any idea why?
Reply With Quote
  #2  
Old 11-21-2022, 05:34 AM
macropod's Avatar
macropod macropod is offline Sorting does not produce an alphabetical list. Windows 10 Sorting does not produce an alphabetical list. Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,927
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

How are you producing the Index - with XE & INDEX fields, or some other way? And how are you doing the sort? When I paste your text into a document, then convert the text to a table and sort the table, a correctly-sorted list results.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-21-2022, 06:48 AM
alanterrill alanterrill is offline Sorting does not produce an alphabetical list. Windows 10 Sorting does not produce an alphabetical list. Office 2010
Novice
Sorting does not produce an alphabetical list.
 
Join Date: Nov 2022
Posts: 5
alanterrill is on a distinguished road
Default

Thank you - the index has been produced by someone else, now deceased, and is in three separate documents. I've converted these from pdfs to text files, cut and pasted them into one document, then highlighted all the text and clicked the sort button. This puts all the individual letters together correctly but doesn't work within a single letter. I didn't realise the text had to be in a table format for the sort to work. I've just converted it to table and re-run the sort, but it still doesn't perform the sort correctly. Here's a portion of the sorted table:
Ellwood, Mr J.C.P. 14;9
Elm Cottage, Stoke Mandeville BU, fence 21;10
Elphick, S. Harold 12;14
Elshof, De, Malden (NL) 20;8
Elswoud, Overveen (NL), folly group 4;3
Eltham, Orangery LO 61;6
Elvaston Moorish Temple DB 72;20
Endsleigh Cottage orné, Milton Abbot DV 62;15
English Garden, Tsaretsyno, Moscow RUS 70;17
English Heritage (EH)61;3 64;3
English Rococo Garden, The (Michael Symes) 63;18
Engravings, Thomas Smith of Derby 65;5
Enstone Grotto OX 67;11
Enville, Gothic Gateway (Sanderson Miller), ST 64;12
Epsom, Temple Banqueting Hall, Hylands SR 72;4
Essex, Gothic Temple, Hatfield Priory 65;5
Essex, Jumbo, Water Tower, Colchester EX 64;8
Etchells, Frederick 69;19
Evans, Carmen 61;19 63;18

Elton CA, temple 44;5
Elton Hall CA, hermitage 44;15
Elton Hall SH, folly group 40;15
Elvaston Castle DR, folly 46;15
Reply With Quote
  #4  
Old 11-21-2022, 07:19 AM
alanterrill alanterrill is offline Sorting does not produce an alphabetical list. Windows 10 Sorting does not produce an alphabetical list. Office 2010
Novice
Sorting does not produce an alphabetical list.
 
Join Date: Nov 2022
Posts: 5
alanterrill is on a distinguished road
Default

I've turned on the show/hide feature and I can now see that all the rows within that single large row have a carriage return symbol after each row, whereas the others have a square symbol (table cell marker I think). How would I convert the rows in the large field into individual table rows? I've tried find and replace but can't find a caret character for 'table cell marker'

I've attached an image of the part of the list that isn't sorting.

Attached Images
File Type: jpg Capture.JPG (64.0 KB, 16 views)
Reply With Quote
  #5  
Old 11-21-2022, 07:24 AM
alanterrill alanterrill is offline Sorting does not produce an alphabetical list. Windows 10 Sorting does not produce an alphabetical list. Office 2010
Novice
Sorting does not produce an alphabetical list.
 
Join Date: Nov 2022
Posts: 5
alanterrill is on a distinguished road
Default

I've tried replacing the carriage return symbol with a paragraph symbol using ^l and ^v in sort and replace, but it comes out all in a line like this:
Attached Images
File Type: jpg Capture2.JPG (47.5 KB, 17 views)

Last edited by alanterrill; 11-21-2022 at 10:56 AM.
Reply With Quote
  #6  
Old 11-21-2022, 12:02 PM
Charles Kenyon Charles Kenyon is offline Sorting does not produce an alphabetical list. Windows 11 Sorting does not produce an alphabetical list. Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 8,377
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

While this is an index, it is not one produced by Word's Index feature.

I would replace the line breaks ^l with paragraph breaks ^p and then covert the table to text.
Then remove any unneeded paragraph marks and sort.
You could either put the Sort command on your QAT or convert the text back to a table, perhaps a single-cell table, so you could use the Sort command it the Ribbon.
Reply With Quote
  #7  
Old 11-21-2022, 12:45 PM
kilroyscarnival kilroyscarnival is offline Sorting does not produce an alphabetical list. Windows 10 Sorting does not produce an alphabetical list. Office 2021
Competent Performer
 
Join Date: May 2019
Posts: 189
kilroyscarnival is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
While this is an index, it is not one produced by Word's Index feature.

I would replace the line breaks ^l with paragraph breaks ^p and then covert the table to text.
Then remove any unneeded paragraph marks and sort.
You could either put the Sort command on your QAT or convert the text back to a table, perhaps a single-cell table, so you could use the Sort command it the Ribbon.
This is almost what I did with the data pasted above to try it. I pasted into Word and saw the line returns, Find/Replace ^l to ^p, then converted the text to a table, breaking contents on the paragraph.

When sorting, I found I didn't get results until I changed the Sort By from the first cell's text to Column 1 as found in the dropdown, as shown below. Then it sorted. You could, then, convert the table back to a text, or simply make the table gridlines invisible if that suited better (handy for updating.)

Ann
Attached Images
File Type: jpg table_sort.jpg (79.2 KB, 16 views)
Reply With Quote
  #8  
Old 11-22-2022, 12:31 PM
alanterrill alanterrill is offline Sorting does not produce an alphabetical list. Windows 10 Sorting does not produce an alphabetical list. Office 2010
Novice
Sorting does not produce an alphabetical list.
 
Join Date: Nov 2022
Posts: 5
alanterrill is on a distinguished road
Default

Thanks for these tips, I've now been able to resolve the issue.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting on created paras - alphabetical by topic sknanda Word 8 07-01-2020 12:05 AM
Sorting does not produce an alphabetical list. How to change alphabetical order in Word for sorting in a foreign language BobK Word Tables 1 12-01-2017 05:17 PM
Create Index List Using Bookmarks in Alphabetical Order priteshp108 Word VBA 8 11-16-2015 12:06 PM
Easiest Way to Produce a Report/List of Tagged Text from Multiple Word Files bxchk Word 5 04-29-2014 03:23 PM
Sorting does not produce an alphabetical list. Find in alphabetical order list 14spar15 Word 1 12-03-2011 03:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft