Hello – I have 3 lines of data WITHIN a cell. The data within cell was put on separate lines by hitting Alt-Enter. This has created some Non printable “quotation marks “ at the beginning and end of the cell data. When I use the Clean( ) function it removes the “quotation marks “ but it also merges the 3 lines into one line. I need to keep the data within the cell on its separate lines but remove the non printable characters.

The ultimate goal is to save the excel file as a CSV with non printable characters removed. Also the information should stay on separate lines within the cell.

Thank you for your time in advance! BM