Is Excel Alt Enter same as Newline character n

Question

I am loading data from excel column which contain multiple lines separated by alt+enter. can i use the new line \n in java to match this alt+enter in data loaded from the cells during validation? is alt+enter in excel same as \n ?

Answer 1

According to the excel documentation, pressing alt+enter causes char to appear (10). Because char(10) is a Line-Feed (LF) character, it is the same as n in Java.

The typewriter movements of dragging the page carriage back to the start and scrolling it up a line are designated r (CR) and n (LF).

In Excel, Alt+Enter corresponds to CR+LF in Windows Format. We may check by pasting the appropriate text into Notepad++ from an Excel cell that contains Alt+Enter (check the below snapshot)

In Excel, Alt+Enter is a Line Break character that works in the same way as Chr (10)