DEV4 Blog

  • Home
  • /
  • Blog
  • /
  • Microsoft Excel: CONCATENATE

CONCATENATE is a neat function within Excel which allows you combine the data from multiple cells into a single cell. This can be used for many purposes, for example combining first and last names to show a full name, or, as shown below, combining cities with their country.

To use this function, we simply type =CONCATENATE(), with the cells to be combined inside the parenthesis. Doing this will give a combination of the exact cells selected, so to add a space in between the cells we add double quotations around a space to the formula, or to add a comma we add double quotations around a comma into the formula.

In the example shown below, we have used the CONCATENATE function to combine the capital city with its corresponding country, separating them with a comma and a space.

 

Published on 03 Mar 2021 by Joanna Hepburn

Add new comment...