The Problem
Address data often arrives split across several columns, which is fine for storage but awkward for printing labels or exporting to another tool. If the building, street, and city stay separate, the user has to mentally rebuild the address every time.
That becomes annoying in shipping lists, event invites, customer exports, and any workflow where another system expects one readable mailing line. The challenge is not just to glue cells together, but to keep the order, commas, and spaces consistent so every label reads the same way.
The flow below shows the merge problem. Three useful address pieces need to become one clean output that can be counted and exported.
The Problem: Separate Address Parts Need One Mailing Line A clean delimiter keeps merged labels readable and consistent.
In this workbook, the building, street, and city fields are already separated. The challenge is to combine those fields into one full mailing address for every row, then complete the audit cells that count the source records and processed labels.
- The source address pieces should stay in their original columns.
- The merged label should use the same comma-space separator every time.
- The audit should confirm how many labels were created.
That gives the sheet a clean output without hiding the original data. If a label looks wrong later, the user can still trace it back to the separate address pieces.
How We Solve It
We want one text string that combines columns A, B, and C with a comma and a space between each part. That means the real work is not the merge itself but keeping the delimiter clean and consistent across every row.
Method 1: Use the ampersand operator
Method 1: Join each column manually with commas and spaces.
The ampersand operator is the simplest way to join text in Excel. It gives full control over punctuation, which makes it a good option when the label format is short and fixed.
This solves the challenge by building the mailing label piece by piece. Each address part stays in the right order, and the commas and spaces are added exactly where the final label needs them.
=A2 & ", " & B2 & ", " & C2
Method 2: Use TEXTJOIN
Method 2: Let TEXTJOIN handle the separator for the whole row.
This is the method used in the solution. TEXTJOIN applies the same delimiter across the selected range and keeps the formula shorter than a long chain of ampersands.
This solves the challenge in the cleanest way because the delimiter rule only has to be written once. The formula joins the three address columns into one mailing label while keeping the punctuation consistent across every row.
=TEXTJOIN(", ", TRUE(), A2:C2)
Method 3: Use CONCAT for simple joins
Method 3: Use CONCAT for a simpler join when no advanced delimiter logic is needed.
CONCAT is useful when you only need to glue text together and you do not mind typing the separator pieces yourself. It is simpler than TEXTJOIN, but less convenient when the same delimiter repeats a lot.
This solves the same merging problem when the layout is simple and the user wants a straightforward join. It is especially useful when the final label does not need much repeated delimiter logic.
=CONCAT(A2, " ", B2)
Function Explanation
1. TEXTJOIN
TEXTJOIN combines multiple text values with a delimiter you choose. In this worksheet, it keeps the mailing-label format consistent across all rows.
That is helpful because the delimiter only has to be written once. The row range supplies the address pieces, and the formula handles the punctuation between them.
2. Ampersand
The ampersand operator joins one piece of text to another. It is a basic but very useful option when the output format is simple and you want full control over every separator.
It is more manual than TEXTJOIN, but it makes every comma and space visible in the formula, which can be useful for short labels.
3. COUNTA
COUNTA counts non-empty cells. Here it is used in the summary to count the original records and the number of merged labels that were produced.
That gives the audit section a simple completeness check: the number of processed labels should match the number of address rows.
Learn more this functionCOUNTA
The small detail that matters most is the separator. A missing comma or missing space can make a merged label harder to read even if the data itself is technically complete.
Merge the building, street, and city columns into one mailing label, then finish the summary so the worksheet shows how many records were in the list and how many labels were successfully produced.