Forum Discussion
Find And Replace to Add Line Breaks within Cells
Excel does not recognise "Ctrl J" in the find/replace dialog box, in Word you can enter "special characters" there is no option for this in Excel
I don't know about other platforms, but Excel for Windows does recognize Ctrl+J in the Find/Replace dialog. You should see the insertion point (the blinking vertical bar) disappear except for one pixel.
Thank you yes, the killer is the different behaviour of Word which actually displays ^l (L) for line feed. This was compounded by Excel not recognising a tilde ~ which was the character I was trying to replace. Exactly why MS cannot get two of the key products to behave in the same way is rather strange.
There is a long history of legacy behind this. If Microsoft changed this now, it would break millions of documents or workbooks...