Tag Archives: CONCATENATE

Using financials in Mail Merges

Imagine you have a financial figure that you want to use in a mail merge (a salary, bonus, house prices etc.) If you use them as they stand, they'll likely look rubbish. They won't show the currency and there won't … Continue reading

Most useful spreadsheet ever? Excel-based year calendar

I created an Excel year calendar recently. Here's a link to it. It's completely dynamic, allowing you to show the calendar for any year between 1900 and 9999. The only user interaction is to enter the year. The rest of … Continue reading