Text Manipulationbeginner
TEXTJOIN a column into one cell
=TEXTJOIN(", ",TRUE,A2:A20)
Excel how-to guide
How to concat full address in Excel
Build a mailing label column from separate address fields, or create a full-name column from first and last name columns.
Step-by-step instructions
How to concat full address — 3 steps
1
List each piece of data you want to join as separate arguments.
2
Insert literal text strings like ", " between arguments to add the punctuation and spacing you need.
3
The formula assembles them left to right in the order you specify.
Example data
Worked example
| Street | City | State | Zip |
|---|---|---|---|
| 123 Main St | Springfield | IL | 62701 |
| 456 Oak Ave | Shelbyville | TN | 37160 |
Common mistakes
Errors to watch out for
CONCAT vs CONCATENATE
CONCAT is the modern replacement for CONCATENATE and accepts ranges. CONCATENATE requires individual cell references and does not accept ranges.
Missing spaces in result
CONCAT does not add separators automatically. Include your spaces and commas as literal string arguments between each cell reference.
FAQ
Frequently asked questions
Can CONCAT handle an entire column range?
Yes — CONCAT(A2:A20) joins all non-empty values with no delimiter. Use TEXTJOIN when you need a delimiter between each value.
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides
Continue learning.
Text Manipulationbeginner
TEXTJOIN for full name building
=TEXTJOIN(" ",TRUE,A2:C2)