The Concatenate Function
To be able to concatenate data in Excel, you must have data from multiple cells that you need to group 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 screenshot examples below:
=CONCAT(C2,". ",B2," ",A2," "D2)
- How to Create a Simple List Box in Microsoft Excel 2016
Creating a list box (drop-down menu) in Excel can reduce data input and increase your work flow. Use these steps to create a simple list box in minutes that may save you hours of time.
- Create a Macro Button in MS Excel 2016 to Filter Data
The article will show you how to create a set of buttons allowing you to filter a table within a spreadsheet and revert to your original view quickly. A document template for the task will be provided.
- How to Add the Developer Tab in MS Excel 2016
This article shows you how to navigate through the MS Excel options menu to enable visibility of the developer tab within the Excel main menu.
To learn more about using functions in Excel I recommend purchasing Excel Formulas & Functions For Dummies.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2018 Joshua Crowder
Joshua Crowder (author) from Tampa, FL on February 04, 2018:
Awesome! I hope to make a lot of hubs about Excel. Do you use Excel for your job?
Louise Powles from Norfolk, England on February 04, 2018:
I'm a new user to excel, so still learning how to use it. So reading this has been very helpful. Thankyou.