Combining text in Excel streamlines data entry and reporting, making your worksheets cleaner and easier to read. This guide shows reliable methods for joining cell contents with or without separators using formulas and tools.
You can merge cells quickly using keyboard shortcuts, but you should prefer formulas so that results update automatically when source text changes. The following sections walk through the most common workflows and advanced options.
| Method | Formula | Best For | Dynamic |
|---|---|---|---|
| Ampersand Operator | =A2&B2 | Simple joins | Yes |
| CONCATENATE | =CONCATENATE(A2,B2) | Backward compatibility | Yes |
| TEXTJOIN | =TEXTJOIN(" ", TRUE, A2:B2) | Custom separators and ignore blanks | Yes |
| CONCAT | =CONCAT(A2:B2) | Range joins | Yes |
| Flash Fill | Pattern-based | Quick manual merges | No |
Using Ampersand to Merge Text
The ampersand operator (&) is the simplest way to combine text from multiple cells into one cell.
Basic Concatenation
Use =A2&B2 to join two cells directly without any space or delimiter.
Adding Custom Separators
Insert quotes around characters to control spacing or punctuation, as in =A2&", "&B2.
Using CONCATENATE for Compatibility
The CONCATENATE function behaves like the ampersand but can be clearer when building longer formulas.
Classic Syntax
Write =CONCATENATE(A2, " ", B2) to include a space between pieces and maintain broad Excel version support.
Using CONCAT and TEXTJOIN for Modern Workflows
Newer functions handle ranges and ignore blanks more intuitively.
CONCAT for Range Joins
=CONCAT(A2:A10) combines all cells in the range into one string without a built-in separator.
TEXTJOIN with Delimiters
=TEXTJOIN(", ", TRUE, A2:C2) joins cells with a comma and space, ignoring empty cells for cleaner output.
Flash Fill and Power Query Alternatives
When you prefer point-and-click tools, Flash Fill and Power Query offer fast, visual ways to merge text.
Flash Fill for Pattern Recognition
Type a sample result, then press Ctrl+E to let Excel detect and apply the pattern across rows.
Power Query for Batch Processing
Use Power Query to merge columns once and apply the change to an entire table in a repeatable way.
Best Practices for Combining Text in Excel
- Prefer formulas such as TEXTJOIN or CONCAT so results update when source data changes.
- Use consistent separators like spaces, commas, or dashes to keep merged text readable.
- Wrap text output with CHAR(10) and wrap text for clean multi-line entries.
- Test your formula on a few rows before copying it down the entire column.
- Consider Power Query for large datasets to merge text in a reusable, automated flow.
FAQ
Reader questions
How do I combine first and last names with a space in Excel?
Use =A2&" "&B2 or =CONCATENATE(A2, " ", B2) to insert a space between the first and last name.
Can I merge cells while ignoring empty cells in the result?
Yes, use =TEXTJOIN(" ", TRUE, A2:C2) so that blank cells are skipped automatically.
What is the difference between CONCAT and CONCATENATE?
CONCAT supports ranges, while CONCATENATE requires individual cell references; both produce the same joined text. Use =A2&CHAR(10)&B2 and apply wrap text to the result cell so the line break displays correctly.