Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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: 9,584
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
  #2  
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
Expert
 
Join Date: May 2019
Posts: 363
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
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, 19 views)
Reply With Quote
  #3  
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



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 07:05 AM.


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