How to Concatenate Data in Microsoft Excel 2016
Concatenate In Excel
Concatenate Function Introduction
To be able to concatenate data you must have data from different cells that you need to group together in a single cell. If you want to follow along with the data in this tutorial download the file here.
Step 1: Adding the Concat Function
Go into the cell where you would like to join cells and type "=concat(", then type in the cell location of the first cell in the series. Each location needs to be separated by a comma. Continue typing in the other locations in the series separated by commas in the order that you would like the information to appear.
Step 1: Add Function
Notice below that all the data is pushed together. You can edit the spacing in-between each text string by adding two quotes and another comma with whatever data or spacing that you want within the quotes.
Step 2 Correct Spacing
If I only want to place a period after Mr then this is what the formula would look like without the outer quotes "=CONCAT(C2,".",B2,A2,D2)". I'd really like to add two spaces between each word, so I'll add two spaces after the comma, then add two more sets of quotes with two spaces between the next text strings. See text and screen shot examples below:
=CONCAT(C2,". ",B2," ",A2," "D2)
Step 2: Spacing Added
This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.
Questions & Answers
© 2018 Joshua Crowder