Sorting Data in Microsoft Word
Most people seem to know that you can sort data in Microsoft Word, but don't
know or remember how.
Simply select the data, and hit TableŕSort.
(Yes. Even if your data is not in a table.)
One of the most common reasons you'll get the error "Word found no valid
records to sort"...
...is because your data has line breaks instead of carriage returns. Turn on
your Show/Hide button to see what's breaking your lines.
The following shows
line breaks instead of carriage returns.
If this is true with your data—which is often the case when copying from the
web—you can use Find and Replace to replace the line breaks with carriage
returns, as shown:
The Find what box contains a carat (^) and a lower-case letter L.
The Replace with box contains a carat (^) and a lower-case letter P.
Hit Replace All. Your data will now look like this.
You can learn other find/replace codes by hitting the More and Special
buttons of the Find and Replace dialog.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved