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.
Category: Microsoft Excel
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.
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.
From time to time, Excel worksheets fill up with blank cells interspersed among the content. While the judicious use of whitespace can be useful, it may also make reading the worksheet somewhat challenging. Luckily, Excel has a tool to help us get rid of the blank cells. Here’s how:
I recently had a user call in and ask me how he could export the contents of a single worksheet to PDF while working in Microsoft Excel 2010. As I told him, that is a simple feat to achieve. Here is how: