Windows  |  Free Downloads

 

 

 

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 datawhich is often the case when copying from the webyou 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

privacy policy