Buy us a Ko-Fi
Or support us via PayPal
Or buy from Amazon to help keep this site ad free
to our site members
MS Excel | combine data with the CONCAT function

MS Excel | combine data with the CONCAT function

Excel CONCAT function

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,"!")
Add a comment

Leave a Reply

Your email address will not be published. Required fields are marked *