TOP

Text concatenating from different cells

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” (&):

Related articles:

  • Text concatenation by condition (CONCATIF)
  • Breaking text into multiple columns
  • Automatic text splitting by specified delimiter (SPLITUP)