Tag Archives: Excel 2007

Excel: moving from menu to ribbon, pt. II

I did say, in the post Excel: moving from menu to ribbon, that getting a friendly developer to write a custom menu set-up for you to replicate the old 2003 menu is not the way to go. Irrespective, I consider myself both friendly and a developer so we do actually have an add-in available, for those who’d like to disregard my previous advice. Continue reading

Excel: moving from menu to ribbon

For users of Excel the change from the familiar old menu bar, in Excel 2003 and earlier, to the new ribbon, in Excel 2007 or 2010, things can be a bit of a shock. Things aren’t where you expect, some may not even be in a place you consider sensible. But, now you’ve upgraded, let’s look at a way to deal with this. Continue reading

Excel: Extract a substring…starting from the end

Now there’s a whole heap of posts, forum answers and articles out there on how to find a substring in Excel by playing around with formulae. The problem that almost all of these have is that they assume you always want to start from the beginning of the string. But what if you need to find information from within the string instead? Continue reading

Excel: Merging CSV Files The Easy Way

For reasons which are best not explained, I was given some large data exports that had been created as a dozen or so Excel sheets (to the tune of 40,000+ lines per sheet) and asked to convert them into something more useful. Specifically, a CSV file. Continue reading

Word: Updating Autofields

MS Word is a peculiar beast and it should be remembered that, just because it comes out of the Microsoft stable, this doesn’t mean it works the same as MS Excel. There are some obscure reasons for this peculiarity but, rather than go into these in depth, I’ll limit the scope of this article to a specific question posed recently. Continue reading

Excel: Data Sort Using More Than 3 Columns

Excel was designed so that a user can sort by 3 columns, and that’s it. Why 3? Who knows, maybe the developers figured that 3 would be enough for any user of Excel and if they wanted more they’d be using a different application entirely. For whatever reason, that’s what we’re stuck with when using the Data>Sort tool provided. Continue reading

Excel: Defined Names

A Defined Name is a text descriptor created by the user/developer to describe content, meaning or use of a cell or range of cells, a constant, or a formula. Once defined this can be used in place of cell addresses or other content and makes formulae much easier to understand and/or maintain.  Continue reading