TaraAlexander
New Member
- Joined
- Jun 6, 2018
- Messages
- 4
I have a list that looks like:
<tbody>
</tbody>
Need a formula to make it look like:
<tbody>
</tbody>
Address |
1820 E River Rd Ste 230Tucson |
7550 E Mcdonald Dr Ste AScottsdale |
442 Kaleimamahu StHonolulu |
6 Larch Ave Ste 398Wilmington |
85 Willow StNew Haven |
64 Thompson St Ste A105East Haven |
PO BOX 2590416 Slater RoadNew Britain |
7059 Blair Rd Nw Ste 300Washington |
1018 Bienville StNew Orleans |
11131 N Oak Hills PkwyBaton Rouge |
1304 Business Park DrTraverse City |
1118 W Front StMonroe |
121 Hunter Ave Ste 205Saint Louis |
<tbody>
</tbody>
Need a formula to make it look like:
Address | Address 1 | City |
1820 E River Rd Ste 230Tucson | 1820 E River Rd Ste 230 | Tucson |
7550 E Mcdonald Dr Ste AScottsdale | 7550 E Mcdonald Dr Ste A | Scottsdale |
442 Kaleimamahu StHonolulu | 442 Kaleimamahu St | Honolulu |
6 Larch Ave Ste 398Wilmington | 6 Larch Ave Ste 398 | Wilmington |
85 Willow StNew Haven | 85 Willow St | New Haven |
64 Thompson St Ste A105East Haven | 64 Thompson St Ste A105 | East Haven |
PO BOX 2590416 Slater RoadNew Britain | PO BOX 2590416 Slater Road | New Britain |
7059 Blair Rd Nw Ste 300Washington | 7059 Blair Rd Nw Ste 300 | Washington |
1018 Bienville StNew Orleans | 1018 Bienville St | New Orleans |
11131 N Oak Hills PkwyBaton Rouge | 11131 N Oak Hills Pkwy | Baton Rouge |
1304 Business Park DrTraverse City | 1304 Business Park Dr | Traverse City |
1118 W Front StMonroe | 1118 W Front St | Monroe |
121 Hunter Ave Ste 205Saint Louis | 121 Hunter Ave Ste 205 | Saint Louis |
<tbody>
</tbody>