In the previous instalment of Sunday Skills, I shared how to use Text to Columns in order to “split” columns of information. Today, let me demonstrate the “opposite”, using the Concatenate function in order to “merge” multiple cells, with text and/or numbers, into a single cell. This will be useful if you have a first…

The text to column function in Exel lets you “split” a column of organised data into multiple ones. Let’s take the example of participating to a compensation survey. You need to provide employee name, employee title and employee date of birth. The date of birth should be in format YY, ie only 2 digits for…