Look Who it Was Random video

Excel - Master Excel Data Sorting in Word | Sort by Paragraph & Use EO Month Function - Episode 951

907 views · Published 16 February 2009 · 2:44 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master Excel Data Sorting in Word | Sort by Paragraph & Use EOMonth Function.

Welcome back to the MrExcel netcast! In this episode, we're going to tackle a common issue that many Excel users face - sorting data in Word. But first, let's start with a quick pivot table to analyze our massive amount of data. 

In a previous episode, I mentioned using the EO month function to find the first of the next month. However, this function was only available in the analysis tool pack for Excel 2003. But now, with Excel 2007, it's built in and easily accessible. Simply use the EO month function with a comma and the number of months you want to go out, and you'll have the correct date. 

Moving on to our main topic, sorting data in Word. Many people believe that data can only be sorted in Word if it's in a table. But thanks to a tip from Melanie, we now know that you can actually sort by paragraph. Just press [ctrl A] to select all the text, go to the table tab, and click on "sort by paragraph." You can then choose to sort ascending or descending. 

But wait, there's more! Melanie also shared a helpful trick for creating the data in Word. Instead of using hard returns, use a text breaking return by going to insert, break, and selecting "text wrapping break." This will ensure that the sort function works correctly. Thank you, Melanie, for this valuable tip! 

And lastly, a shoutout to Jamie from the U.K. for reminding us about the EO month function. It's always great to have a function that was previously only available in the analysis tool pack now built into Excel. Just make sure to only use it if you're sharing your workbooks with others who have Excel 2007. 

Thanks for tuning in to this episode of the MrExcel netcast. Don't forget to subscribe and hit the notification bell to stay updated on our latest videos. And if you have any Excel or Word tips to share, leave them in the comments below. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Jamie shows how to use EOMonth to find the first of next month and Melanie shows how to sort paragraphs in Word. Episode 951 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Introduction
(00:14) Correcting issues from previous episode
(00:24) Using EO month function in Excel 2007
(00:35) Formatting the result of EO month function
(00:47) Using EO month function with different parameters
(01:02) Sorting data in Word without a table
(01:30) Using text breaking return for sorting in Word
(01:57) Shoutout to Melanie for the Word tip
(02:07) Reminder about EO month function
(02:22) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Analysis tool pack
Data sorting in Word
EO month
Excel master pin
MrExcel netcast next time
Pivot table
Sharing workbooks
Sort by paragraph
Text breaking return
Word tip


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152181/

More from this channel