Handling addresses split across multiple columns

This is a super common question with a very quick solution. It’s also a great Excel/Google Docs trick to know with a ton of other uses.

Uploading to Storemapper requires that your address is all on one line in one column like:

| full address |

| 123 Main St. Washington, DC 20001 |

But sometimes you have your raw data split across columns. Something like this:

| street              | city                | state | zipcode |

| 123 Main St. | Washington | DC    | 20001   |

The following video is a very quick way to combine all those columns into one in seconds and paste them into our template. Of course, if you get stuck on this, just email us the CSV and we’ll help you sort it out.

Was this article helpful?

Related Articles