Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2023, 10:48 AM
donnje's Avatar
donnje donnje is offline Alphabetical order Windows 10 Alphabetical order Office 2010
Novice
Alphabetical order
 
Join Date: Jun 2023
Posts: 13
donnje is on a distinguished road
Default Alphabetical order

Hi,
I get an error if I try to sort alphabetically, why?



SwissTransfer.com - Envoi securise et gratuit de gros fichiers
Reply With Quote
  #2  
Old 07-08-2023, 03:51 AM
Guessed's Avatar
Guessed Guessed is offline Alphabetical order Windows 10 Alphabetical order Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The paragraph that says
Monastero San Pedro de Arlanza
is causing the problem. If you move that paragraph out of the list then it sorts OK but any sub-selection that includes that line will fail to sort.

I don't know why that one is different but if you toggle to view the field codes rather than the result you can see that line is formatted differently.

You can remove the hyperlink from that line and it will then sort.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 07-08-2023, 06:32 AM
donnje's Avatar
donnje donnje is offline Alphabetical order Windows 10 Alphabetical order Office 2010
Novice
Alphabetical order
 
Join Date: Jun 2023
Posts: 13
donnje is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
The paragraph that says
Monastero San Pedro de Arlanza
is causing the problem. If you move that paragraph out of the list then it sorts OK but any sub-selection that includes that line will fail to sort.

I don't know why that one is different but if you toggle to view the field codes rather than the result you can see that line is formatted differently.

You can remove the hyperlink from that line and it will then sort.
thanks now it'work
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Note books in alphabetical order Jazz OneNote 0 08-07-2017 10:24 AM
Create Index List Using Bookmarks in Alphabetical Order priteshp108 Word VBA 8 11-16-2015 12:06 PM
O 2007 folders & files lose alphabetical order in John Seed Outlook 0 02-28-2012 05:56 PM
Alphabetical order Find in alphabetical order list 14spar15 Word 1 12-03-2011 03:01 PM
Some contacts are not in alphabetical order in Outlook 2007 marko959 Outlook 0 04-21-2011 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:00 AM.


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