Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2022, 12:07 AM
Over65 Over65 is offline WORD Text Sort Limitation Windows 10 WORD Text Sort Limitation Office 2021
Novice
WORD Text Sort Limitation
 
Join Date: Jan 2022
Posts: 4
Over65 is on a distinguished road
Default WORD Text Sort Limitation


When I do a text sort of the lines of a WORD document it only sorts on a fairly limited number of characters from the left. What is this maximum number of characters and can I increase the number used?
Reply With Quote
  #2  
Old 01-24-2022, 07:38 AM
Charles Kenyon Charles Kenyon is offline WORD Text Sort Limitation Windows 10 WORD Text Sort Limitation Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
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

Lines or paragraphs?
A paragraph in Word jargon is anything followed by a paragraph mark, which is typed using the Enter key.

I know of no published specs on this. Where have you run into a limit? I am confident you cannot increase the number used in the user interface. If you did the sort using a macro, my guess is that the limit would be 256 characters.
Reply With Quote
  #3  
Old 01-24-2022, 07:46 AM
Over65 Over65 is offline WORD Text Sort Limitation Windows 10 WORD Text Sort Limitation Office 2021
Novice
WORD Text Sort Limitation
 
Join Date: Jan 2022
Posts: 4
Over65 is on a distinguished road
Default

Doing the standard paragraph sort of a WORD document appears to use a sort field of only the first part of a line/paragraph and not the whole line/paragraph. I have not tested to find what this relatively short length is as yet. Where can I find advice as to how to set up a better sort using macro? Thanks.
Reply With Quote
  #4  
Old 01-24-2022, 10:26 AM
Charles Kenyon Charles Kenyon is offline WORD Text Sort Limitation Windows 10 WORD Text Sort Limitation Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
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

I just tried it and it was working at 63 characters. Checked with 112 characters all the same and it did not sort those by the 113th character. To me, 63 characters is not all that short.

I expect that someone here will provide a macro that does more. I remember doing bubble sorts in my computer science class, but that was a long time ago. If you do not get a response here in the next couple of days, try posting in the Word VBA Forum. Do wait, though, or close this question and post there.
Reply With Quote
  #5  
Old 01-24-2022, 01:22 PM
Over65 Over65 is offline WORD Text Sort Limitation Windows 10 WORD Text Sort Limitation Office 2021
Novice
WORD Text Sort Limitation
 
Join Date: Jan 2022
Posts: 4
Over65 is on a distinguished road
Default

Thanks for doing that testing. The number of characters you want depends on why you want to sort and the nature of the content. I want/need to sort based on the whole paragraph/line not just a front piece of it.
Reply With Quote
  #6  
Old 01-24-2022, 04:56 PM
Guessed's Avatar
Guessed Guessed is offline WORD Text Sort Limitation Windows 10 WORD Text Sort Limitation Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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

If the sort has a maximum character limitation then perhaps you need to split it across multiple cells.

If it was me doing it, I would save the file as a text file and import that into Excel and tell the import to split lines at a fixed character position (eg 60). Then sort on multiple columns and paste it back into Word as Text Only.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 01-24-2022, 05:08 PM
Over65 Over65 is offline WORD Text Sort Limitation Windows 10 WORD Text Sort Limitation Office 2021
Novice
WORD Text Sort Limitation
 
Join Date: Jan 2022
Posts: 4
Over65 is on a distinguished road
Default

Thanks for your suggestion, but I am wanting something quicker and easier within WORD itself.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reputation limitation Jennifer Murphy Forum Support 2 02-22-2020 07:17 AM
WORD Text Sort Limitation What is the Word sort order for text? Jennifer Murphy Word 2 01-27-2017 07:18 PM
Nr characters limitation when merging polygos Publisher 0 06-11-2016 08:27 AM
How to sort word text in alphabetic order . crossing Word 8 01-20-2012 09:51 AM
WORD Text Sort Limitation Mail Merge 2007 Limitation Butch Jackman Mail Merge 3 07-23-2007 09:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:39 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