How to Combine Two Columns in Excel
Learn how to combine two columns in Excel using formulas, ampersand, TEXTJOIN, Flash Fill, separators, mistakes, troubleshooting, and FAQs.
Quick Answer
To combine two columns in Excel, use a formula such as =A2&" "&B2, then fill it down. Use TEXTJOIN if you need separators and want to ignore blanks.
What You Need
- Excel worksheet
- Two columns to combine
- Blank result column
- Separator such as space or comma if needed
- Backup for important data
Safety Precautions
- Do not overwrite original columns until you verify the combined results.
- Use Paste Values before deleting source columns.
- Check blank cells and extra spaces.
- Review formulas before sorting or filtering.
Step-by-Step Instructions
- Step 1
Insert result column
Add a blank column where the combined text will appear.
- Step 2
Write formula
Type =A2&" "&B2 to combine cells with a space.
- Step 3
Change separator
Replace the space with comma, dash, or no separator as needed.
- Step 4
Fill down
Drag or double-click the fill handle to copy the formula.
- Step 5
Check results
Look for extra spaces, blanks, or missing values.
- Step 6
Paste values
If you need fixed text, copy the formula results and paste as values.
- Step 7
Keep or remove sources
Delete source columns only after confirming the pasted values.
Practical Example
Example: You combine first name in A2 and last name in B2 with =A2&" "&B2 to create a full name.
Common Mistakes
- Deleting source columns before paste values
- Forgetting separator quotes
- Overwriting data
- Leaving extra spaces
- Not filling down all rows
- Sorting formulas without checking references
Troubleshooting
Formula shows as text
Change the cell format to General and re-enter the formula.
Extra spaces appear
Use TRIM around the formula result or clean source cells.
Blank cells cause awkward separators
Use TEXTJOIN with ignore blanks if available.
Results disappear after deleting columns
Paste formula results as values before deleting source data.
Helpful Internal Links
FAQs
What formula combines two cells?
=A2&" "&B2 combines A2 and B2 with a space.
Can I combine columns with commas?
Yes, use =A2&", "&B2.
What does TEXTJOIN do?
TEXTJOIN combines values with a separator and can ignore blanks.
Can Flash Fill combine columns?
Yes, type an example result and use Flash Fill if Excel recognizes the pattern.
Related Guides
How to Move Columns in Excel
Learn how to move columns in Excel by drag-and-drop, cut and insert, table tips, formula checks, common mistakes, troubleshooting, and FAQs.
How to Add Drop Down List in Excel
Learn how to add a drop down list in Excel using Data Validation, source lists, error alerts, common mistakes, troubleshooting, and FAQs.
How to Apply Conditional Formatting in Excel
Highlight values, duplicates, dates or formula-based conditions in Excel and manage rule order and cell references.
Help us improve this guide
Tell us about an outdated instruction, unclear step, broken link or safety concern. Do not include passwords, account numbers, medical records or other sensitive information.