The name of the function does sound long and technical,
however, it is one of the easiest functions to use in Excel.
Concatenate is useful when you want to join or 'string' together two or more pieces of text. What this means is that you can merge the
content of two or more cells into one cell using the Concatenate function.
Try using this function in the practice file here.
Try using this function in the practice file here.
There are two ways to use this function:
1) =concatenate(Cell1,Cell2,…)
Using this function, you can keep
selecting the cells that you want to combine and insert comma after every cell.
2) =Cell1&Cell2&cell3&…
Using this technique, you can use
& (ampersand) symbol to string the different cells together
Important points to note:
The function or the technique just blindly merges the cells
together. If you want to include spaces or other symbols like comma between the
two strings, you will have to modify the function and use it like this:
=concatenate(cell1,” “,Cell2,” “,…)
OR
=Cell1&” “&Cell2&” “&cell3&…
You can replace the space with symbols of your choice.
Easily Excel at Concatenating!
Check other functions here.
Learn how to quickly format your excel sheet here.
Check other functions here.
Learn how to quickly format your excel sheet here.
