#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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.
|
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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.
|
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
Thanks for your suggestion, but I am wanting something quicker and easier within WORD itself.
|
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 |
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 |
Mail Merge 2007 Limitation | Butch Jackman | Mail Merge | 3 | 07-23-2007 09:44 AM |