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.