Remove line breaks in excel
When you receive data from other systems into Excel, the cells often contain line breaks that can cause problems in other calculations. Alternatively some users know how to use the ALT ENTER option which creates line breaks within a cell. Either way, line breaks are seen as characters in excel and as a result you cannot compare 2 cells if one has a line break and the other doesn’t.
To fix this you can try one of 2 things.
- At a simple level you can just click in the cell and delete the break but this is not very useful when you have thousands of cells.
- So a way to do this is the use the CLEAN function (see video clip) to remove the line break. You would normally combine this with a TRIM function which removes unnecessary spaces as well.