Ongoing Nightmare - Opening a .txt. or .csv containing HTML script

[freshfrost]

This has been an ongoing problem that I can not figure out. Every time I open a file in excel (.txt or .csv) with html script, it parses the script as well as the columns. These files are coming from an outside source so I do not have the liberty of asking them to use a different delimiter to prevent the issue. How I can import the following example and keep it from parsing incorrectly?


Column A
001-12,February,<br><br>test, why, me</br>who knows</br>


BECOMES


Column A|Column B|Column C| Column D| Column E
001-12 February <br><br>test why me</br>who knows</br>


Instead of:
Column A|Column B|Column C
001-12 February <br><br>test, why, me</br>who knows</br>

 

[arthurbr]

Cross posted at at least 4 other forums

 

[freshfrost]

Cross posted at at least 4 other forums

No offense but I really wish people focused more on the question than the cross post. Yes, I posted the question in several forums because I am DESPERATELY trying to find an answer to this ongoing problem - hence "Ongoing Nightmare" in the title. I am stuck because of this delimiter issue with the html in several worksheets. Obviously, once the question was answered with a working solution, I would post answered or closed. You will see this response posted in all the other threads complaining about the same issue so I will save you the trouble.


Now, can someone please help me resolve this issue?