Learn how to use excel to extract numbers from strings.
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.
Update: No Break Key? See Part 2 to this article So, last month I finally got my new work system. It is a nice Dell Precision M4500 running an Intel Core i5, 8GB RAM, tons […]
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 […]
Could not install the custom actions. The object could not be found. I’ve gotten that error more than once from Outlook 2007. The error will appear every time you try to open an eMail and […]