Find And Replace to Add Line Breaks within Cells

Copper Contributor

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 the Line Break code???

1 Reply


Enter $$ in the 'Find what' box.

In the 'Replace with' box, press Ctrl+J. This enters a line break.