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:

      =CONCATENATE(A1,B1,C1).
       
    • 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.
       


    OR



    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.
         

      OR



        • 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.