Is Excel Alt Enter same as Newline character n

0 votes
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 ?
Mar 25 in Database by Edureka
• 13,640 points
464 views

1 answer to this question.

0 votes

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)

Snapshot from Notepad++

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

answered Mar 30 by gaurav
• 22,040 points

Related Questions In Database

0 votes
1 answer

When is the functional dependency known as fully functional dependency?

The criteria of fully functional dependency, is ...READ MORE

answered Aug 10, 2018 in Database by DataKing99
• 8,240 points
1,808 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
775 views
0 votes
0 answers

Merging Two excel files as two sheets in one workbook in java

I have two xlsx files at folder ...READ MORE

Mar 10 in Database by Edureka
• 13,640 points
647 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Are there such things as variables within an Excel formula?

Yes. However, not directly. a less complicated method You ...READ MORE

answered Mar 25 in Database by gaurav
• 22,040 points
64 views
0 votes
1 answer

How to read and write excel file

When broken down into steps, reading an ...READ MORE

answered Mar 25 in Database by Edureka
• 13,640 points
109 views
0 votes
1 answer

How to read and write excel file

When broken down into steps, reading an ...READ MORE

answered Mar 30 in Database by gaurav
• 22,040 points
82 views
0 votes
1 answer

VBA Excel - Replace Enter key with Alt+ Enter

I created Button1 and assigned the Enter ...READ MORE

answered Apr 11 in Database by gaurav
• 22,040 points
286 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

answered Feb 21 in Database by gaurav
• 22,040 points
177 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP