Can you use text to columns? Yes, Did you know a linefeed Character can be the delimiter? Maybe :) In this video, I demonstrate how this can done. The power tools can handle this without dropping a sweat but it is always nice to see how much more Excel can do, when you know how
Workbook can be found here
https://drive.google.com/open?id=1nTR...