My SpreadSheet Magic

"&" Ampersand vs Concatenate function in joining Cell Content

In this Blog I will show you how a simple character "&" called ampersand can replace the Concatenate Function of Excel and Google Sheets.

The Ampersand technique is the Faster way of joining Cell content instead of using Concatenate Function

Course 4 Process Data from Dirty to Clean, Week 2, Video on Optimize Data-Cleaning Process on Google Analytics, talks on the use of Concatenate function to join one cell data to another cell data.

In this case we have the following scenario:

Reference File:

Course 04_Week 02_Lesson 13_Cleaning data with Spreadsheets_Cosmetics INc - Data for Cleaning

H2 data : 51993 I2 data : Masc

To join the content of H2 and I2 Concatenate function is used as per video instruction.

K2 formula : =Concatenate(H2,I2) K2 result : 51993Masc

To use the function concatenate is longer to type. The best and faster alternative is to use the shortcut method, just use the ampersand "&" to join one cell to another. Here is the the example which creates the same result. K2 formula : = H2&I2 K2 result : 51993Masc

Hope this trick will help you well with your data analytics venture. Cheers!

posted by Noel J @ 12:50 PM