Advanced methods to concatenate cells | Microsoft Excel | Xyclos
Updated: Sep 19
When we need to concatenate or join cells, we have several functions that can help us with this:
Concatenate
Concat
Textjoin
Suppose we have to join 3 cells that are in Row 2 , we need to concatenate them with a blank space as a separator, what do we do?
Standard method
Use the CONCATENATE function =CONCATENATE(A2," ",B2," ",C2)
Use the CONCAT function =CONCAT(A2," ",B2," ",C2)
Use & =A2&" "&B2&" "& C2 The & operator ( Ampersand ) is used to join cells without using a function
Advanced method
It's a bit long to enter as many blanks as there are so many cells we need to join, so what can we do?
Use the & operator to join cells, but additionally establishing a range of cells:
Use the CONCAT function: =CONCAT(A2:C2&" ") Excel will join each cell in the range with a blank space because we have established it that way when using the & Ampersand operator
Use the TEXTJOIN function =TEXTJOIN("",,A2:C2) The difference between CONCAT and TEXTJOIN is that the latter, in the second argument, incorporates the option to ignore empty cells that are in the selected range
Note
Instead of using white space as a separator, we can use as separators: the comma, the semicolon or any text or value that we need to join to the range of cells:
=CONCAT(A2:C2 & " , ") =TEXTJOIN(" , ",,A2:C2)
Learn step by step and master Microsoft Excel like a Pro, with our excellent online courses at two levels:
Invest in improving your knowledge ! Get started today!
#CursosOnlineMicrosoft #Xyclos #Microsoft #CursoDeExcel #CursoPowerBI #CursosdeProject #CursoOnline #Learning #JobGrowth #MicrosoftExcel #MicrosoftWord #MicrosoftPowerPoint #MicrosoftOutlook #cursosexcel #powerquery #powerbi #datascience #chatgpt #prompt #prompts #midjourney #tech #technology #business
Comments