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>