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.
This challenge brings those pieces together into one full mailing label. Once the merged address is in place, the bottom of the sheet simply checks how many records were processed.
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.
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.
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.
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.