The concatenated data is full of formulas with equals signs and ampersands in it. We'll then copy the Full Names column into the Name column of the Builder template.
#Concatenate excel download
In this example, we set up a speakers list, so you'll want to download a custom list template from Builder if you haven't already. Next, we need to put your information in a Builder template. You have successfully used concatenation to manipulate the data in your spreadsheet. Select all the rows below C2 in column C and paste the formula. We'll apply this formula to all of the rows so we don't have to type it again which will be a huge time-saver.Ĭlick on C2-the cell that says “Andrew Kaufman”- and copy it. This tells your formula to include a space between the cells' data. Your formula should read: “=A2&" "&B2”.Ĥ.Click Enter or Return on your keyboard to apply this concatenation formula. Type quotation marks, space, quotation marks, ampersand: " "&. With the cell C2 selected, click in the formula (fx) bar after the first ampersand ( &).Ģ. However, since we'd like there to be a space between the first and last names, we need to modify the formula.ġ. You should see a Full Name in cell C2 that reads “AndrewKaufman”.Ĭongratulations! You have successfully concatenated this data. Click Enter or Return on your keyboard to apply this concatenation formula. Then click on the cell B2. Your formula should read “=A2&B2”.ħ. Type an ampersand (the “and” symbol that looks like &).Ħ. With the cell C2 selected, click in the formula (fx) bar. Then click on cell C2 just below the “Full Name” column header.ģ. Click on the cell C1, to the right of “Last Name”, and type in “Full Name”.Ģ. We need to combine-or concatenate- the data in our spreadsheet so it will fit in Builder's template.ġ. In a Custom List template, however, the “Name” is just one cell.
When you open the attachment at the bottom of this article, you will see a list of First Names and Last Names in columns A and B. We'll work through an example below.īefore diving in, please download and open the Concatenation Practice.xls spreadsheet attached at the bottom of the walkthrough so you can follow along. The ampersand tells Excel to join the contents of cells A2 and B2 into a single string of text. In general, to concatenate cells together, you'll use a formula that looks something like this “=A2&B2”. We can use concatenation to efficiently make this change across multiple rows of data at once. However, for Builder to read your imported template properly, we will need to put the speaker's full name in one cell. In spreadsheets, you may have content in multiple cells that need to be combined - or concatenated - into one cell.įor example, you may have a spreadsheet of speakers where the First Name and the Last Name are in two separate cells. What Is Concatenation?Ĭoncatenation is a way of saying combination.
#Concatenate excel how to
With concatenation, you can more quickly and effectively manipulate your data so Builder knows how to read it. We know that your schedule or list data might not fit neatly into our Builder templates at first.