Searching for Line breaks inside a cell MS Excel
Sometimes you will find a line break (new paragraph/line) inside a cell in Excel.
And if you need to remove all unnecessary line breaks in a sheet.
To find and replace in Excel, you can use “Alt+0010” inside the Find & Replace box.
You will not see anything in Excel’s F&R box, but the code is there.
You can replace all line breaks with either a space or nothing.
I found this tip/trick on http://www.necco.ca/dv/ppt_excel.htm
I will upload some screenshots also after some time.