Problem importing pipe delimited csv file as html runs over

[pigeon]

Hi All,

I'm really hoping that someone can shed some light on the problem I'm having.

I have been trying to work on a pipe delimited csv file, however when I open the file some of the html data, which is between the pipe delimiters has moved into adjacent cells.

I specifically chose pipe as the delimiter knowing that the html codding and the product descriptions would cause problems with the usual delimiiters.

Does any one have any suggestions?

Regards Paul