Merge First and Last Name Cells Into One Cell in Excel 2013. The steps below are going to use a formula to combine a cell with a first name and a cell with a last name into one cell. If you delete the original, separated cells, then the data in the combined cell will be deleted as well.

• Click on cell C2 to make it the. • Click on the Formulas tab. • Choose Text Functions from the to open the function drop-down list. • Click on CONCATENATE in the list to bring up the function's dialog box. • Click on line Text 1 in the dialog box. • Click on cell A4 in the worksheet to enter that cell reference into the dialog box.

• Click on line Text 2 in the dialog box. • Press the Space Bar on the keyboard to add a space to line Text 2.

Excel adds double quotation marks around the space. • Click on line Text 3 in the dialog box. Wondershare free youtube downloader for mac. • Click on cell B4 in the worksheet to enter that cell reference into the dialog box. • Click OK to close the dialog box and return to the worksheet.