Combine addresses into 1 line
When you export orders from Boxify, the address is split across two columns: shippingAddress1 and shippingAddress2. Some shipping platforms require a single address line. This article shows you how to combine them.
Here is an example of what your exported sheet looks like:
| shippingAddress1 | shippingAddress2 |
|---|---|
| 1 Harimau Street #02-16 | |
| Blk 3000A Bukit badak street 25 | #22-58 |
| 100 Tigerlands Ave 5 | #04-02 Bellewoods |
| Bukit Tiger west ave 4 blk 407 #04-100 | |
| Harimau Central Blk 220B #04-38 | |
| Blk 36 Jalan Rumah Panjang | #21-5000 |
| 80 Lowview Avenue , #08-05 | Singapore |
Watch the video above to see how to merge these two columns into one line using an Excel formula.
If you need to do the reverse โ split a combined address back into two columns โ watch the video below.