Skip to content

Category: Office Technology

Change your Outlook reading pane

Some people don’t like the reading pane on in Outlook. It is easier to cull messages viewed as lines of data. But sometimes the first few lines of the message can be helpful in making the delete/keep decision.

Fixing combined data in Excel

While there are many ways to fix combined data like “Chicago, IL, 60660,” many are fragile and not suited to connected data sources in a workbook.

Excel dates: Just add 1

If you need the day number within the year for a particular date, subtract 1/1/2020 or the first day of the current year with which you’re concerned. Then add 1.