Forum Discussion
DennisGalon
Apr 05, 2024Copper Contributor
Find And Replace to Add Line Breaks within Cells
Within a Cell Alt + Enter introduces an invisible Line Break or New Line Code. Believe that code is Char(10) How do I use Find & Replace to Find characters (let's say $$) and replace this with t...
Gracey56
Apr 14, 2025Copper Contributor
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.
HansVogelaar
Apr 15, 2025MVP
There is a long history of legacy behind this. If Microsoft changed this now, it would break millions of documents or workbooks...