Combine Cells in Excel for Mailing Addresses

To combine address parts into one cell, put the street in A2, city in B2, state in C2, and ZIP code in D2, then enter =TEXTJOIN(", ",TRUE,A2,B2,C2&" "&D2). For example, 125 Oak Avenue, Madison, WI, and 53703 become “125 Oak Avenue, Madison, WI 53703.” This creates a combined result in a separate cell; it does not merge the original cells.

What You’ll Need

An Excel workbook with each address part in its own column. A practical layout is street in A, city in B, state or region in C, and ZIP or postal code in D.
A blank column for the finished address, such as column E. Keep the original columns until you have checked the results.
Microsoft Excel for Microsoft 365 on Windows for the steps below. The formulas also work in Excel for the web and current Excel for Mac; ribbon placement may differ slightly.

Before starting, check that the first row of your data is consistent. If row 1 contains headings, use row 2 for the first address and adjust the examples if your data starts elsewhere. If you have apartment numbers, country names, or other address parts, decide where they belong and how you want separators to appear. Excel will join the values you provide, but it will not verify that an address is deliverable or put its parts in the correct local postal format.

Step-by-Step

Check and label the source columns. Put one address component in each column rather than typing a whole address into one cell. For the examples in this guide, A is Street, B is City, C is State, and D is ZIP. Add headings in row 1 so you can identify the fields. Confirm that the same type of information appears in each column; for example, do not mix apartment numbers into the city column. If you already have a different column order, you can use the same approach by changing the cell references in the formula.
Prepare the ZIP or postal-code column. ZIP codes can begin with zero, so preserve them as text when possible. Before entering or importing the codes, select the ZIP column, choose Home > Number Format, and select Text. Then enter the values, including any leading zeros. If the codes are already in the sheet, inspect them first: formatting a number as Text afterward does not restore a zero Excel has already removed. For a US five-digit ZIP stored as the number 501 in D2, the formula =TEXT(D2,"00000") returns 00501. This padding is suitable for five-digit ZIP codes only; keep ZIP+4 codes and international postal codes as text so Excel does not alter their characters.
Choose the output column and enter a heading. In E1, type a heading such as Full Address. Click E2, the first blank cell beside your first address. Keeping the output beside the source fields makes it easy to compare each result with its components. Do not type the completed address over one of the original columns: a formula needs the source values to remain available, and overwriting them can permanently discard data.
Join the four components with separators. With street in A2, city in B2, state in C2, and ZIP in D2, enter =TEXTJOIN(", ",TRUE,A2,B2,C2&" "&D2) in E2. If those cells contain 125 Oak Avenue, Madison, WI, and 53703, respectively, the result is 125 Oak Avenue, Madison, WI 53703. The comma-space separator goes between the street, city, and combined state/ZIP fields; the formula places a regular space between the state and ZIP. Press Enter to calculate the result. TEXTJOIN skips empty cells because its second argument is TRUE, although this particular layout is most suitable when both state and ZIP are present.
Use a blank-tolerant version if some address parts are optional. With the same A2:D2 layout, enter =TEXTJOIN(", ",TRUE,A2,B2,IF(OR(C2<>"",D2<>""),TEXTJOIN(" ",TRUE,C2,D2),"")). If A2 is 125 Oak Avenue, B2 is Madison, C2 is blank, and D2 is 53703, the result is 125 Oak Avenue, Madison, 53703. This version skips empty components and also joins state and ZIP with a space when both exist. It cannot infer a different punctuation rule for every country, so adjust the separator to match the address style you need. If all four fields are required, the simpler formula in the previous step is easier to maintain.
Review the first result before filling down. Compare the output in E2 with the source row. Check spelling, spacing, state abbreviations, and the ZIP code, especially a code that should start with zero. If a component is in the wrong order, edit the formula or correct the source data now. This quick check prevents a mistake from being copied to hundreds of rows. Also click E2 and look at the formula bar: a formula should begin with an equals sign, and the cell should display a value rather than the formula text.
Copy the formula to the other rows. Select E2 and point to the small square at the lower-right corner of its selection border, called the fill handle. Drag it down through the rows that contain addresses. Excel adjusts the row references automatically, so the next result uses A3:D3, then A4:D4, and so on. You can also select E2 and the cells below it that should receive the formula, then press Ctrl+D on Windows. On Mac, use Command+D. If the data is an Excel table, entering the formula in the first output row may fill the calculated column automatically; check that every row was populated.
Check several rows and decide whether to keep formulas. Inspect results near the top, middle, and bottom of the list, including rows with optional or unusual fields. Formula results update if the source cells change, which is helpful for a working address list. If you need a fixed copy for a mailing service or another system, select the completed output cells, copy them, then use Home > Paste > Paste Values. This replaces the formulas with their current results. Keep a copy of the original workbook or source columns before converting formulas to values, because values will no longer update when the component cells change.

If you prefer to avoid TEXTJOIN, a basic formula with ampersands also works. With street in A2, city in B2, state in C2, and ZIP in D2, =A2&", "&B2&", "&C2&" "&D2 returns 125 Oak Avenue, Madison, WI 53703 for the sample values above. The ampersand joins text, but this version includes every separator even when a source cell is blank. Use it when all components are consistently filled, or choose the blank-tolerant TEXTJOIN option when fields may be missing.

Common Mistakes

Confusing combining with merging: Home > Merge & Center combines worksheet cells into a larger cell area; it does not assemble their text into an address. Merging can also discard all but one cell’s contents. Use a formula in a separate output column to retain and join the address components.

Forgetting the spaces and commas: A formula that joins values without separators can produce text like “125 Oak AvenueMadisonWI53703.” Decide where commas and spaces belong before filling the formula down. Conversely, adding a comma after every field can leave stray punctuation when one of those fields is blank.

Losing leading zeros: Excel may interpret a ZIP code as a number and remove its first zero. A custom number format can make the source cell look padded, but a text-joining formula may use the underlying number instead of that display format. Store codes as text, or explicitly format a five-digit value with the TEXT formula shown above.

Replacing the source too soon: Pasting values over the component columns, or deleting them before checking the output, makes it harder to repair errors. Keep those columns until you have reviewed the combined addresses and saved a safe copy.

Tips

Choose separators for the address format you actually need. A common US mailing layout is street, comma, city, comma, then state and ZIP separated by a space. In other countries, the postal code may come before the city, or the address may need a province, district, or country field. Rearrange the cell references and punctuation to match the destination’s conventions; a joined string is not automatically a correctly formatted mailing label.

For apartment or suite information, consider placing it in its own column and including it next to the street. With components in A2 (street), B2 (unit), C2 (city), D2 (state), and E2 (ZIP), you can adapt the formula so the unit is joined to the street with a space or with a label such as “Apt”. Check how blank unit cells should look before copying the formula across the full list. A consistent source layout makes those choices easier.

If you need a label with separate lines rather than one long line, use a line break between the street and city/state. With street in A2, city in B2, state in C2, and ZIP in D2, =A2&CHAR(10)&B2&", "&C2&" "&D2 returns the street on one line and the city, state, and ZIP on the next. Select the result cells and choose Home > Wrap Text to display the line break. The row may need extra height to show both lines.

When the source list is an Excel table, use clear column headings and keep the combined address as a separate table column. Tables can extend formulas as new rows are added, reducing the chance that a new address is left out. After adding records, still check that the formula filled into the new row and that its components use the same conventions as the existing data.

Troubleshooting

The cell shows the formula instead of an address: Check whether the cell is formatted as Text. Change it to General using Home > Number Format > General, then edit the cell with F2 and press Enter. Also make sure there is no apostrophe before the equals sign and that the formula begins with =. If the formula was pasted into a cell while Text format was active, changing the format alone may not recalculate it; re-enter the formula.

The result has missing spaces, commas, or odd punctuation: Review the separator text inside the formula and check whether the referenced columns are in the expected order. A formula cannot determine whether an empty cell means “omit this part,” “leave a blank line,” or “use different punctuation.” Choose the rule you want, then use the blank-tolerant version or change the formula accordingly. Check source cells for spaces at the beginning or end of their contents, which can make a correctly joined result look uneven.

The first zero in a ZIP code is gone: If Excel already converted 00501 to the number 501, simply changing the cell format to Text cannot restore the lost digit. If every value should be a five-digit US ZIP, use the TEXT formula with the 00000 format shown in the steps. If the list contains ZIP+4 or other postal codes, correct or reimport those values as text instead of padding every value to five digits.

Some rows did not get a result: Look for gaps in the output column and repeat the fill-handle or fill-down step for the missing range. If the range is an Excel table, confirm that the new records are actually part of the table. Also check whether a source row is entirely blank; a blank result may be expected rather than a formula failure.

Excel displays an error after entry: Confirm that parentheses and quotation marks are balanced and that the formula uses commas between function arguments. The examples are written for standard Microsoft 365 settings. Some regional settings use semicolons as argument separators; if Excel rejects a formula with commas, use the separator expected by your installation. Do not replace the commas that are inside quoted address text unless you intend to change the displayed punctuation.

Frequently Asked Questions

Is combining cells the same as merging cells?
No. Combining address cells means joining their contents into a text result, usually with a formula. Merging makes multiple worksheet cells occupy one larger area and does not combine all their contents. For address lists, use a formula and preserve the original cells.

Which formula is best for joining address fields?
TEXTJOIN is convenient because it accepts a separator and can ignore empty cells. For a complete street, city, state, and ZIP row, the simple TEXTJOIN example is easy to read. Use the blank-tolerant version if fields can be empty. Ampersands are also valid for a fixed layout with no missing parts.

Can I join more than four address columns?
Yes. Add the extra cell references in the order you want them to appear, and decide whether each part needs a space, comma, or line break. For example, include a unit column beside the street or a country column at the end. Review a few results before filling down because extra components may require different punctuation.

Will the combined address update if I change a source cell?
Yes, while the output contains a formula, Excel recalculates it when a referenced value changes. If you paste the output as values, it becomes a fixed text copy and will not update. Keep the formula version if the source data is still being edited.

Can I put each address on multiple lines in one cell?
Yes. Join the parts with CHAR(10) where you want a line break, then turn on Wrap Text for the result cells. If the row height does not show the full address, increase it or use Home > Format > AutoFit Row Height. The resulting cell still contains one value, even though it displays on several lines.

Do these steps work on Mac or in Excel for the web?
The formulas work in current Excel for Mac and Excel for the web. On Mac, use Command+D rather than Ctrl+D to fill selected cells down. Ribbon labels or locations can differ slightly by platform, but the same separate output-column approach applies.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.