Marge Simpson) and cell B2 contains their date of birth (e.g. Let's say cell A2 contains someone's name (e.g. You can solve this with the TEXT function, which you can use to define the required format. If your original cells contain formatted numbers like dates or currency, you'll notice that the combined cell strips the formatting. Related: How to Merge Excel Files and Sheets Alternatively, left-click and drag the bottom right corner of the filled cell down the column. To do this, double-click the bottom right corner of the filled cell. You don't need to manually type in each cell name that you want to combine. Once you have placed the formula in one cell, you can use this to automatically populate the rest of the column. You can combine as many cells as you want using either method. Using the former works to combine two columns in Excel, but it is depreciating, so you should use the latter to ensure compatibility with current and future Excel versions. This formula used to be CONCATENATE, rather than CONCAT. Click the cell where you want the combined data to go.Ĭlick the first cell you want to combine.Ĭlick the second cell you want to combine.įor example, if you wanted to combine cell A2 and B2, the formula would be: =CONCAT(A2,B2)
