What do we need to concatenate text from different cells? For executing this in Excel is special function, which named CONCATENATE. This function is in tab formulas in partition Text:
Let’s look at how it works. Firstly select the function and input data there:
We will get the following result:
As we can see the function just “glues” the text. Also we have inputted gaps as additional argument, otherwise the text will be shown as a one word.
Also exists another approach to merge text – is to use special character, which named “ampersand” (&):