Skip to content

Category: Microsoft Excel

Outlook: Mail merge

I have previously written about one of my many responsibilities; contacting users whose login credentials have shown up in breach lists. While the pertinent results of the breach files are delivered to me in a flat file, I use Excel’s Text to Columns feature to separate logins (usually email addresses) from the password. While this might take a little fiddling with the delimiters, it is worth it to ensure that you have a good basis on which to work.

Leave a Comment

Excel: Text to Columns

I work a lot with text files containing data which is, to some degree or another, structured. Whether a breach file from a published breach, or the result of a powershell query such as Get-ADUser, Get-ADComputer, or Get-ADDirectReports, I need to separate the data into columns so that I can work with it. This is where the Text to Columns feature in Excel comes in handy.

Leave a Comment

Excel freezes on 10 MB file

A few months ago, I had a user call in complaining that Excel would freeze and become completely unresponsive when she was working in a specific workbook. It was fairly large (10MB), but well within what the computer should have been able to handle. I opened a remote session to the computer, and started troubleshooting. My first step, as always in these cases, was to look at the event logs, which showed no relevant entries. Next, I inspected one of the files in question.

Leave a Comment