Recently, I had to pull customer numbers out of strings from an excel sheet. Sure, you can use trickery like spaces to columns or regex. Excel is pretty powerful, if you know all of the text tools at your disposal. This is how I extracted the numbers for random text
I recently had to use back end data from SQL Server to deliver several reports in excel. All of my SQL code gave me results in seconds; however, the users had distinct formatting requests. I would have to use a few excel tricks to get things just right in each report.
Continue reading “Working with Seconds in Excel”
Learn how to get your remote desktop back to full screen after Minimization Continue reading Remote Desktop won’t go back to Full Screen after Minimization in Windows 7
I was formatting the several of my machines the other day and I was moving files back and forth. Sure, for MP3s or videos, I use an external USB hard drive. But there are smaller files, such as the Adobe … Continue reading Unshare Folders in Windows 7
Learn how to fix the error “Could not install the custom actions” message Continue reading Could not install the custom actions