worksheet function - How to search for newline or linebreak ...

21 Dec 2011 ... In Excel the standard line break Alt + Enter character is ASCII 10. ... keypad) the character code, i.e., Alt 0010 for just the line break, or Alt 0013 (release Alt and press again) Alt 0010.

superuser.com