Don’t be put off by this terminology, the concatenation of cells is one handy little Excel feature that is fabulous. Basically, it means combining the values of two cells. The great thing about Excel is that it has functions that work with arithmetic functions but it also ones that work well with text and Concatenation is one of them.
Heres an example of when you might find this useful.
Suppose you have a first name in one cell and last name in another column, and you need to combine then in one cell for a mail merge or some other administration exercise. There are actually two ways to concatenate the information
1. Use the built-in formula in the new cell where you want the new information
=Concatenate and follow instructions on screen entering the first text, then the second. Hit return and voila your results are displayed.
Or this way which some people find a lot easier..
Lets suppose you have the same scenario where you want to combine first and last names in to one column. Typing the following will achive this
2. =A2&” “&B2, we want a space betweent he first name and last name so we put a space between the quotes “”.
Go ahead and give them a go unleash the power of ‘Concatenation’