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

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>

Also posted here:
http://www.msofficeforums.com/excel/...html#post71160
http://www.ozgrid.com/forum/showthread.php?t=191143

Hi, freshfrost,

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.excelforum.com/excel-gene...ml-script.html

http://www.ozgrid.com/forum/showthread.php?t=191143

Ciao,
Holger

Cross link has been added. This was the first post which is why one was not originally included.

Originally Posted by HaHoBe

Hi, freshfrost,

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.excelforum.com/excel-gene...ml-script.html

http://www.ozgrid.com/forum/showthread.php?t=191143

Ciao,
Holger

Also cross posted at http://chandoo.org/forum/threads/ong...2/#post-116696 and at MrExcel

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?