MS Excel | the CONCAT function

2 min read

As you become more proficient with Microsoft Excel, it’s conceivable that you might find yourself in a situation where you need to concatenate. Which is where we link or chain together data into a series. For example you might need to chain together someone’s first and last name, so that you have their full name.

Note: In Microsoft Excel the CONCATENATE function is in the process of being deprecated in favour of CONCAT. While the two commands will do the same thing. Microsoft recommend that you use CONCAT rather than CONCATENATE, as Excel will eventually no longer recognise CONCATENATE.

The syntax for the CONCAT formula is as follows:

=CONCAT(text1," ",text2)

Note: After instructing Excel to use the CONCAT function. We then need to tell Excel what will be the first piece of data we will be joining together. Next we have a comma which instructs Excel to move onto the next action. The space between the quote marks, then tells Excel to add a space, before it joins the first piece of data with the second.

With this being an example of an actual CONCAT formula:

=CONCAT(A1," ", A2)

Note: We can also use commas and quote marks to create sentences for data. For example:

=CONCAT("Welcome ",A1," ",A2,"!")

mydoodads article – MS Excel | Customise your instance of Excel.
mydoodads article – MS Excel | How to turnoff the Startup screen.
mydoodads article –

Microsoft article – CONCAT Function.
Microsoft article – CONCATEATE function.

MS Excel | the CONCAT function

Add comment

Cancel reply

Login

Our site members

Support This Site