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...
GraceAA
Feb 26, 2025Copper Contributor
In case anyone else stumbles on this question, this is the answer for an in-cell line break
Ctrl+H to bring up the Replace popup
Find What = ,
Replace With = here press "Ctrl+J"
Press Replace
swens2005
Jul 15, 2025Copper Contributor
You are a hero!! I've been looking for this for 15 years! :)