Posts

Microsoft Excel tutorial: Combine/ Concatenate/ cells, Reverse Concatenate / split cell, find repeats/duplicates

Image
Combine data/ Concatenate (merge) cells in Excel spreadsheets: 1.        Combine two cells A and B (First name and Last name) 2.        Paste =CONCATENATE(A3, " ", B3) in C3 3.        Click enter and drag to C13 Reverse Concatenate or split cell text into separate columns 1.        Choose the right column or cells. Here Full name column A3 to A11 2.        Click on Data tab in the File, Home row 3.        Click on Text to Columns 4.        Click on Convert Text to Columns Wizard 5.        Click on Delimited (or Fixed Width as per requirement) 6.        Click on Next. 7.        Choose the appropriat...
Post a Comment
Read more

Install Ubuntu in external Hard drive from a Windows system

Image
Install Ubuntu in external Hard drive from a Windows system Advantage: There is no difference in performance if Ubuntu is installed in external hard drive or internal. It is always preferred to install Ubuntu in external hard drive if you have dual boot system as you do not have to allocate space in internal hard drive. Requirements: 1)       A pendrive / USB Flash Drive 2)       An external HD D   Step 1:   Download Ubuntu in .iso file format.   You can download the latest version from https://www.ubuntu.com/download/desktop . Or you can download older reliable version Ubuntu 16.04.5 LTS as the newer version may not be compatible with many software from http://releases.ubuntu.com/16.04/ Click on the link 64-bit PC (AMD64) desktop image Step 2: make USB bootable.   From the site https://rufus.akeo.ie/ download Rufus. No need to install Rufus. Insert your pe...
Post a Comment
Read more