How do I split an address into separate columns in Excel?

Data > Text to Columns with a comma delimiter, or =TEXTSPLIT(A2, ", ") on Microsoft 365. Both leave State and ZIP together and stumble on addresses with a different number of parts. Tellsheet's Parse Address splits into Street, City, State, ZIP, and Country and separates the State from the ZIP for you.

Why doesn't Text to Columns split an address cleanly?

Because addresses are irregular: the State and ZIP usually sit in one comma field ('Springfield, IL 62704'), some rows have a country and some don't, and a missing comma shifts everything into the wrong column. A parser that understands address structure handles those cases.

Can I split a US ZIP+4 or a UK postcode?

Yes — Tellsheet's Parse Address recognizes US ZIP and ZIP+4, UK postcodes, and Canadian postal codes, placing them in the ZIP column. It's best-effort, so review the output on unusual formats.

Home › Excel Guides › Split an Address into Columns in Excel

How to Split an Address into Columns in Excel

One column of full addresses, and you need Street, City, State, and ZIP apart. Text to Columns gets you close then leaves "IL 62704" stuck together. Here's the manual route, and a one-click parser.

Last updated: August 2026

Address		Street · City · State · ZIP
123 Main St, Springfield, IL 62704	→	123 Main St · Springfield · IL · 62704

Method 1 — Text to Columns

Data > Text to Columns > Delimited > Comma.
Excel splits at each comma — but the last field is usually State ZIP together, so you split again by space, and any row with a missing comma lands out of line.

Method 2 — TEXTSPLIT (Microsoft 365)

=TEXTSPLIT(A2, ", ") spills the comma parts across columns. Elegant, but you still separate State from ZIP by hand, and addresses with a different number of parts don't line up.

The 1-click way — Tellsheet

Parse Address splits a full address into Street, City, State, ZIP, and Country columns, pulling the State and ZIP apart and recognizing US ZIP / ZIP+4, UK postcodes, and Canadian postal codes. It's a best-effort parser tuned for comma-separated US/UK/Canada-style addresses — brilliant on clean data, so always spot-check unusual formats. The sibling tool for people's names is Split Names.

Frequently asked questions

How do I split an address into columns?

Text to Columns by comma, TEXTSPLIT on 365, or Tellsheet's Parse Address (which separates State from ZIP for you).

Why doesn't Text to Columns split it cleanly?

Addresses are irregular — State and ZIP share a field, countries are optional, and a missing comma shifts columns. A structure-aware parser handles it.

Does it handle ZIP+4 and UK postcodes?

Yes — Parse Address recognizes US ZIP/ZIP+4, UK postcodes, and Canadian codes. It's best-effort, so review odd formats.

What about people's names?

Use Split Names to break full names into first and last columns.

Related Excel guides

Parse addresses in one click

Parse Address splits a full address into Street, City, State, ZIP, and Country — right inside Excel.

Get Tellsheet free See pricing