If you run Marc's code, then it will do basically what I suggested. It will create a file called "Export .txt" and put it in the same folder as your Excel file. The you can open that file with Notepad.

It uses a very clever method of extracting all the data in one line of code. It will start in P2 and extract the CurrentRegion. However, CurrentRegion will include other columns besides column P if there is data in the adjacent columns, and will cause a runtime error on the call to Join. So it should be tested with your actual data.