How to Combine Two Columns in Excel & CSV Without Losing Data

To combine two columns in Excel with a space between them, enter =A2 & " " & B2 into an empty column, fill down, and paste values before deleting the original columns. When handling messy exports, blank cells, or five-column addresses where formulas break or strip leading zeros, the visual combiner handles the join directly in local browser memory without helper columns.

Method Comparison: Manual Formulas vs 1-Click Browser Combiner

Each approach fits a different situation. Live formulas make sense when source cells keep changing inside desktop Excel; a one-time transform makes more sense when preparing CRM imports, mailing lists, or database CSVs.

Method 1: Combine Columns Manually in Desktop Excel or Google Sheets

Option A: Using the Ampersand (&) Operator

The & operator works in every version of Excel back to Excel 97 as well as Google Sheets and LibreOffice Calc:

1. Click cell C2 next to your first data row (assuming headers live in Row 1).
2. Type =A2 & " " & B2 and press Enter.
3. For a comma separator (such as Austin, TX), use =A2 & ", " & B2. For SKU codes separated by a hyphen, use =A2 & "-" & B2.
4. Double-click the small square fill handle in the bottom-right corner of C2 to copy down all rows.
5. Critical step before deleting A or B: select column C, press Ctrl+C, right-click → Paste Values (V). Deleting source columns first turns every formula into #REF!.

Option B: Skipping Blank Cells with TEXTJOIN

Merging mailing addresses breaks down with basic & formulas whenever Address Line 2 is empty, leaving ugly results like 410 Main St, , Austin, TX. Use TEXTJOIN instead:

=TEXTJOIN(", ", TRUE, B2:E2)

Setting the second argument to TRUE skips empty cells cleanly. Remember to clean stray whitespace first if imported cells contain invisible space characters; TRIM paired with column cleaning stops empty-looking cells from inserting extra commas.

Method 2: Combine Multiple Columns in 1 Click (No Formulas Needed)

When you only want the finished table ready for CSV, TSV, Markdown, or a clean Excel download, helper columns slow you down. Open the interactive Combine Columns tool and work straight on the grid:

1. Click Import File to load an .xlsx, .csv, or .tsv sheet, click Paste Data for clipboard rows, or open a sample sheet with Demo Data.
2. Click Combine Columns in the toolbar to open the joiner modal.
3. Check two or more columns in the order you want them joined (for example First Name followed by Last Name).
4. Choose a separator (Space, Comma + Space, Hyphen, Pipe, Slash, Newline, or No Space) or type any custom string.
5. Enter your destination header (for example Full Name). Keep the Keep original columns after combining toggle off if you want the two source columns replaced cleanly by the combined result.
6. Click Combine Now, then open Export Format to save as styled .xlsx, .csv, or clipboard text.

Common Pitfalls That Break Combined Columns

• Lost leading zeros on ZIP codes and SKU numbers: If a postal code like 02134 sits in a numeric Excel cell, Excel already dropped the 0 before concatenation unless wrapped in =TEXT(D2, "00000") & "-" & E2. Importing raw CSV text directly into SheetCombine preserves string characters like 02134 untouched.
• Trailing whitespace inside source cells: Old CRM exports often store "James " with a trailing space, creating double spaces between first and last names. Run Trim in the SheetCombine toolbar once before combining.
• Dates turning into 5-digit serial numbers: Combining a date cell such as 2026-11-11 in Excel produces text like "Invoice 46337" unless wrapped in TEXT(A2, "yyyy-mm-dd"). Convert the date string or format the column beforehand.

Need to go the opposite direction and break a Full Name column back into separate First Name and Last Name columns? Switch directly to the Split Columns tool to split on spaces, commas, dashes, or custom delimiters in the same browser session.