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,