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...
HansVogelaar
Apr 05, 2024MVP
Enter $$ in the 'Find what' box.
In the 'Replace with' box, press Ctrl+J. This enters a line break.
- RobertR2060Aug 25, 2024Copper ContributorDo you happen to know the Ctrl+J equivalent for Excel for Mac, version 16.88
- HansVogelaarAug 25, 2024MVP
Sorry, no idea.