Problem When copying and pasting a table in Microsoft Word, the pasted table seems to not appear. When looking closer you see it was pasted exactly on top of the…
I use Microsoft Word's mail merge feature often. It works great for connecting into a database and spitting out all sorts of documents - but it's kind of clunky when…
By default Windows 10 will occasionally show 'suggested apps' in the start menu. There's really no other way to see these - they are advertisements for the Microsoft Store, and…
The following T-SQL for Microsoft SQL Server shows how to convert line separated text to comma separated text. For example, if we had a table with the following data Lucky_Numbers 2 33…
The following T-SQL for Microsoft SQL Server shows how to search for accented text without having to use the accented characters in the search term. For example, if we had a table…
If you need to create a pivot table chart on a range that includes blank rows you'll end up with a (blank) label. There are several suggested ways to remove…
The following T-SQL for Microsoft SQL Server shows how to find and replace text in a string. In this example we'll change "PO Box" to "P.O. Box". The REPLACE function will search for…
I recently discovered that a brand new USB hard drive promoted as "Apple Mac compatible" was formatted using the NTFS file system. For the non-technical, this file system was created…
In Outlook when you send an email the address is remembered and added to an 'auto-complete' list. The next time you type the email address into the 'to' field (as…