In Excel, column A has a value, column B has a value, and column C has another value. Select one of the two methods below to combine the columns.

Use the CONCATENATE function:

    • Use the CONCATENATE function in column D:

    • In the menu bar, select Insert, Function. Click Text functions and select CONCATENATE.
    • Enter A1 in the text1 field, B1 in the text2 field, and C1 in the text3 field.
    • Click OK. The columns are combined.
    • Copy and paste for as many records as needed.


    Use the & to combine the columns:

      • Select cell D1.
      • In the formula box, enter =A1&B1&C1 and press Enter.

        Note: To enter a character between the columns, such as a dash, set it off with quotation marks. Example: =A1&"-"&B1&"-"&C1

        To enter a quotation mark, enter it in a cell and then reference a cell. You cannot use quotation marks to set off a quotation mark.

      • Select C1.
      • Select Edit, Copy from the menu bar.
      • Highlight the rest of column C where values are to be added. Hold down Control to highlight nonadjacent cells, Shift to highlight contiguous cells, or Page down or arrow keys to page down.
      • Select Edit, Paste to paste the formulas.
      • Highlight the entire column.
      • Select Edit, Copy.
      • Select Edit, Paste Special and select Values only. Now you can delete columns A, B, and C.


        • Click File, Save As and save the Excel file as a .CSV (Comma delimited) file.
        • Close Excel.
        • Right-click on the newly created CSV file and select Open With. Select to open the file in Notepad.
        • Remove the comma between the data values (e.g., First Name and Last Name), making sure to leave a space between them.
        • Click File, Save.
        • Exit Notepad.
        • Reopen the edited CSV file in Excel.
        • Click File, Save As, and re-save the file as an Excel file.