Forum Discussion
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...
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
Try Shift + Ctrl + J
sometimes Ctrl-J works, for some you may need to use the Shift key also. It worked with the Shift key for me; didn't try just Ctrl-J, I found the (better) Ctrl + Shift + J answer elsewhere.
^10 should also work.
If neither of those work, you can always try Alt+0010 on the numeric keypad (note that is four digits, not three).
- If Ctrl + J does not work, press the Alt key, and type 0010 on the number keypad (do not use the numbers above the letters)
^13 or Alt-0013 will work for the Carriage Return ASCII 13 character.