Tag Archives: Excel

Chopping Off Data

Posted on October 19, 2020 by way0utwest

Do you know the difference between XLS and XLSX? They’re both Excel formats, and many of us might just use one or the other. After all, the latest versions of Excel work with both, and if you’ve been using a … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Chopping Off Data

What’s the Mashup Engine?

Posted on April 24, 2019 by way0utwest

I was testing something the other day and ran sp_who2 on a test instance. I saw this in the program listing: I had never seen the Mashup Engine listed in a program list, and I certainly don’t have any program … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Getting the Hyperlink from Excel

Posted on August 30, 2017 by way0utwest

I had a spreadsheet of data that contained hyperlinks. In this case, it was a series of Microsoft Knowledge Base Articles with a hyperlink associated with them. I would assume there’s an easy function in Excel to extract these, but … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Adding Minutes in Excel

Posted on February 22, 2016 by way0utwest

A short one, but I found myself wasting time recently. I use an Excel sheet to schedule some items out each day. It’s not my choice to do this, but the service I use requires this to not manually set … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Adding Minutes in Excel