Now let’s delete the unnecessary columns ( First Name and Last Name columns). So, our cells are freed up from formulas and show only the values. Now press CTRL + C on the keyboard to copy the entire column and press CTRL + V to paste the copied values in the same place.Ĭlick on the CTRL dropdown and choose the Values (V) option from the Paste Values row.
Let’s free up this new column from formulas.Ĭhoose the entire column either using the mouse or using this keyboard shortcut ( CTRL + SHIFT + Down Arrow) when your cell pointer is placed at the first cell of the column.
Now this new column ( Full Name) holds Excel formulas, so we cannot delete our First Name and Last Name column data. You are seeing all the first names and last names are merged into a new column. I press enter and drag down this formula for all the cells (up to there is data) in the column. Now in cell C2, I input this formula: =CONCATENATE(A2," ",B2) We insert a new column after the Last Name and name it as Full Name. 1) Merging two cells using CONCATENATE () function We want to merge two or more cells without losing data. Cell A2 and B2 are merged into one cell A2 and it is only showing the value, Rickey. If you click on the OK button, then cell A2’s value (upper-left) will be intact and cell B2’s value will be discarded. So, I select cells A2 and B2 and click on the drop-down part of the Merge & Center command and choose Merge & Center command from the list.Įxcel will show you a message like the following one. Say, I want to combine ‘First Name’ and ‘Last Name’ parts and want to make ‘Full Name’. In the image below, you are seeing some First names, last names, and some addresses (Address 1, Address 2, and Address 3). You can find more examples and information on the Microsoft Office TEXT function support page.4) Using Text Editor Why cannot you use Merge & Center command in this case? For example, $#,#0.00 would show currency with a thousand separator and two decimals, # ?/? would turn a decimal into a fraction, H:MM AM/PM would show the time, and so on. You can switch out the format for whatever the number requires.
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)