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