Resources > Formula Help
How Do I Combine Text in Excel?
Last Updated: June 2026
Quick Answer
To combine text in Excel, use the ampersand symbol, CONCAT, or TEXTJOIN.
Use the Ampersand
=A2&" "&B2
This combines first and last names with a space between them.
Use CONCAT
=CONCAT(A2," ",B2)
Use TEXTJOIN
=TEXTJOIN(" ",TRUE,A2:B2)
TEXTJOIN is best when combining several cells and ignoring blanks.
Common Mistake
Forgetting spaces between values is common. Use quotes to add spaces, commas, or separators.
