Posts

Showing posts from June, 2014

How to securely erase or wipe disk drives using bootable Ubuntu Live USB thumb drive

Image
If you are planning of selling off your old hard disk drive (HDD) or even USB drive, you might need to do a secure delete of the contents of your old HDD. This will ensure all your personal data in your HDD is unrecoverable using data recovery software. The idea behind this secure deletion or erasure of your HDD content is basically overwriting every bytes of your disk drive with either zeros or random data. This way, whoever that tries to recover the data, they will only see zeros or gibberish data (random data). I like to have a thumb drive preloaded with bootable Live Ubuntu USB thumb drive ready to perform tasks like this. For this post, I am not going to cover the topic of how to setup your USB thumb drive with Ubuntu Live OS. The tutorial is ready available at official Ubuntu website . Once the Ubuntu Live OS is booted up on your PC, there are already built-in commands you can use to perform such secure deletion or erase of your HDD content. There 2 commands that you can use from

How to combine text from 2 cells into 1 cell in Ms Excel

Image
This is how you can combine text contents from 2 cells into 1 cell using formula. You can even insert your custom text in between, before or after the combined text. To combine text contents from 2 cell into 1 cell, use the "&" to join them together: A1&B1 If you want to insert a space in between the 2 combined text: A1&" "&B1 If you want to insert a hyphen in between them: A1&" - "&B1 If you want to add your custom text before the combined text: "custom text "&A1&B1 If you want to add your custom text after the combined text: A1&B1&"custom text" You can also combine the text together using "CONCATENATE" function: CONCATENATE(A1,A2) CONCATENATE(A1," ",A2) via ( http://office.microsoft.com/en-001/excel-help/use-formulas-to-edit-correct-and-proofread-text-RZ006183133.aspx?section=12 )