Join multiple cells in Microsoft Excel using the CONCATENATE function

One of my colleagues was setting up around 400 student accounts for the new year today. He had an Excel spreadsheet with Firstname and Lastname in seperate cells A and B and needed to add two more columns with the students login name (cell C) and email address (cell D).

At first he thought this would have to be a manual process until I showed him how to join multiple cells in Microsoft Excel using the CONCATENATE function. The login name had to take the format firstname.lastname and the email address had to be in the format
Continue reading

HDMI vs YCbCr Digital Component video

I’m going to be cabling our new house soon with Cat6 for phones and data, speaker cabling (more on this later) and I’d like to run something at the same time to future proof us if we decide to purchase a projector in the future. I’ve got to make the decision between running an HDMI cable, of around 10m, into the ceiling, or instead run some cabling for YCbCr Digital Component video (as opposed to analog YPbPr/RGB). This post goes through my thought process when choosing HDMI vs YCbCr Digital Component video
Continue reading

Kim Dotcom and Mega Upload

I fail to see how Kim Dotcom and Mega Upload are guitly of breaching copyright laws. Sure, Mega Upload contained illegal files, but these were taken down immediately at the request of the copyright owner. MegaUpload’s business wasn’t illegal.

If you’re looking to start a legitimate business where – users and businesses can upload their files, give a link to those files to customers or employees for access anywhere and you’re happy to remove copyrighted material, then you’re in the same boat MegaUpload was in.

Do we now take all ISP’s to court? They also provide a service which has the potential to allow illegal filesharing.