Tag: Excel

Excel Spreadsheet Dates Out by Four Years

This might be a bit of an obscure issue but one worth keeping in mind. If you work with Microsoft Excel under both Mac OS X and Windows then you may find an issue with date values changing by themselves when you open them on the other platform (i.e. opening a spreadsheet creating in Mac …

Continue reading

Using Telnet to Delete Mass Amounts of E-mail

For whatever reason, you may end up with a huge amount of e-mail stuck on a mail server and it all just needs to go. Maybe you’ve been lax in clearing e-mail, your e-mail application isn’t managing your mailbox properly or perhaps you’ve just been spammed into oblivion. However, if you’ve got hundreds or even …

Continue reading

Incorporating Carriage Returns into Formulae in Excel Spreadsheets

Following on from yesterday’s tip on how to search for carriage returns in Excel spreadsheets, here’s how you can incorporate this non-printable character into your formulae. The secret sauce for carriage returns is to include CHAR(10) into your formulae. For instance, if you want to concatenate two cells but put the values on different lines in …

Continue reading

Searching For Carriage Returns and Tabs in Excel Spreadsheets

Most people know how to use the search and replace function in Excel spreadsheets but it can be a tricky task if what you’re looking for is a non-printable character like a carriage return (i.e. hitting Enter on the keyboard). Thankfully, it’s easy enough to do once you know how 🙂 In the Find and …

Continue reading

Office 2013 – First Impressions

Last night I decided to try out Office 2013 – perhaps not the smartest thing to do just as the university semester is getting underway but I couldn’t help myself. Anyway, I just wanted to share my first impressions of it with you starting with the installation. First of all, the time between kicking off …

Continue reading

Shrink the Size of a Bloated Spreadsheet

Here’s something to try if you have a spreadsheet that seems to occupy far too much disk space given the content it contains. One sheet at a time, try moving a sheet to a blank workbook and then moving it back to the original workbook until you have done it for all workbooks. I can …

Continue reading

Converting Text Dates to Proper Dates in Excel the Easy Way

From time to time you might receive an Excel spreadsheet that has been created by an application but it has output the dates in its own text format instead of being stored as an actual date value. I’ve seen instances where the time has been placed before the date which would leave many to think …

Continue reading

Windows on ARM Comes with Office 15 Baked In

For people seriously considering a Windows 8 tablet as their next tablet OS here is something that might sweeten the deal a bit. While the iPad has built in viewing capabilities for Microsoft Word documents, Excel spreadsheets and PowerPoint slidepacks the ability to edit them as part of the base operating system is absent. The …

Continue reading

My Web Browser Text is Too Small!

A lot of us would have come across a situation where the text in our web browser just became twice as small for an unknown reason. With so many keyboard shortcuts and buttons on mice it can be hard to work out if you pressed a key or clicked on something by accident to create …

Continue reading

Change the Default Document Format to Office 2003 in Office 2007 & 2010

Change the default document format in Office 2010

More people are making the switch to Office 2007 and Office 2010 however there are still those clinging on to older versions who are unable to open the newer Office 2007 formats (such as .docx and .xlsx which are differentiated from older versions with the extra “x” on the end of the file extension). I …

Continue reading