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

[Fresh Frost Costumes]

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>

 

[Marc L]

Easy ‼ Try a comma and a space as delimiter …​

 

[pecoflyer]

Cross post http://www.msofficeforums.com/excel/22895-ongoing-nightmare-opening-txt-csv-containing-html.html

Please add links to your other cross posts