Hi All, I am looking for some assistance with developing a formula to break up a cell into multiple columns. I have 4 lines to the cell. i need to combine line 1 and 2, break up line 3 into 3 separate cells and then delete the 4th line. I am looking for a formula as I am working on a template so I can drop 13000 lines of data into it and it will break it up for me. the other hiccup is that over the 13000 lines the cell pattern is not always 4 lines. The last line is always Australia. A couple of examples are:
<tbody>
</tbody>
Aylett Street
Coober Pedy SA 5723
Australia
The format I am looking to create is:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
256 Sturt Valley Road Upper Sturt SA 5156 Australia 1708 Riddoch Highway Keith SA 5267 Australia |
<tbody>
</tbody>
Aylett Street
Coober Pedy SA 5723
Australia
The format I am looking to create is:
PAddr1 | PAddrSuburb | PAddrState | PAddrPCode |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>