Removing Lines within a cell in Excel

Hi,

I downloaded a CSV report into Excel.  The last cell of the row contained three lines (assume that after typing each line, you clicked "enter" within the cell).  I need to break the three lines in the cell into 3 cells.  I tried using "Text to Columns", but because of the three lines within the cell, Excel will delete the bottom two line and split the first line.  Has anybody encounter the same issue? If so, how did you resolved it?

Kind Regards,

August 3rd, 2015 9:32am

Not very clear the situation of your problem.

You'd better provide a screenshot about it.

Free Windows Admin Tool Kit Click here and download it now
August 12th, 2015 10:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics