Combine Columns in Excel
Join two or more columns into one - first and last name, address parts, or any fields - with the separator you choose. No formulas, no data loss, and nothing leaves your browser.
Drop your file here or click to upload
Supports .xlsx, .xls, .xlsm, .xlsb, .csv · up to 50MB · or paste a file from your clipboard
How to Combine Columns in Excel Online
- Upload your file - drop in an .xlsx, .xls, .xlsm, .xlsb, or .csv file.
- Tick the columns - select the columns to join, in order.
- Choose a separator - space, comma, hyphen, slash, or none.
- Download - get a new workbook with the combined column added.
Combine vs. Merge Cells
Excel's Merge & Center visually merges cells but keeps only the top-left value and throws away everything else - a common way to lose data. Combining columns is different: it concatenates the values into a new cell, so "Ann" and "Lee" become "Ann Lee" with nothing lost. That is what this tool does, and what a formula like =A2 & " " & B2does - only here you don't have to write or copy the formula.
Features
- Combine any number of columns, in the order you pick
- Custom separator, including none
- Keep or remove the original columns
- Skip empty values to avoid doubled separators
- Works on .xlsx, .xls, .xlsm, .xlsb, and .csv - 100% in your browser
Frequently Asked Questions
Upload your workbook, tick the columns you want to join (for example first name and last name), choose a separator, and download. The values are concatenated into a new column - nothing is overwritten. This avoids Excel's Merge Cells, which keeps only the top-left value and discards the rest.
Yes. Select as many columns as you like; they are joined in the order you tick them, separated by your chosen delimiter.
Your choice. Leave 'Remove the original columns' unchecked to keep them alongside the new combined column, or check it to output only the combined result and the untouched columns.
No. The workbook is read and combined entirely in your browser, so your data never leaves your device.