Problem importing a CSV into Excel with Line Breaks

This is a little convoluted, so forgive me if I take this step-by-step.

I have a large database of information that I have gotten a CSV file for.

In that file there are leading zeros, so I have to import the CSV file so I can tell it to import as text.

That file also contains some data fields that contain line-breaks of some sort. I am not sure what kind.

When I sure the import function, I believe EXCEL is seeing the breaks as 'row-deliminators' and breaking up the data at 'bad' points.

If I just Open the file directly, I do not have the problem with line breaks (all rows line up properly) BUT then I lose my leading zeros.

PLEASE can someone tell me if there is a way to do both these things: Import data with leading zeros, and properly have the rows break?

(The CSV is comma deliminated with " as a text delimiter)

Thank you in advance for any help you can provide.

Hi and welcome to the board
In the message that follows replace "workbook" with CSV file ;-)

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I'm a little hesitant to do so, since the file is a product database for a retail establishment that contains data the company would not want to put out on the internet.

Maybe someone has encountered this problem before and can help with the example?