Skip to main content
Web Applications

Return to Answer

Commonmark migration
Source Link
Community Bot
Community Bot
  • 1

Amendment

New Line in Cell Formula >> CHAR(10)

Example Usage

  • =Concatenate("Line 1", CHAR(10), "Line 2", CHAR(10), "Line 3")
  • =Join(CHAR(10), "Line 1", "Line 2", "Line 3")

Why CHAR(10)?

A new line is also known as a Line Feed. The hexadecimal Unicode Control Code for a Line Feed is U+000A. Therefore, the decimal value of a Line Feed is 10.

This decimal value can be used in the CHAR(...) function in Google Sheets to return the desired character.

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I added the above for those that need new lines in formulas. The below is a snapshot of Dez's answer for completeness :)

Dez's Answer

 

In Edit Mode

 
  • Windows/Linux: Ctrl + Enter or Alt + Enter

    Windows/Linux: Ctrl + Enter or Alt + Enter

     
  • Mac: Command/option(Alt) + Enter

    Mac: Command/option(Alt) + Enter

Amendment

New Line in Cell Formula >> CHAR(10)

Example Usage

  • =Concatenate("Line 1", CHAR(10), "Line 2", CHAR(10), "Line 3")
  • =Join(CHAR(10), "Line 1", "Line 2", "Line 3")

Why CHAR(10)?

A new line is also known as a Line Feed. The hexadecimal Unicode Control Code for a Line Feed is U+000A. Therefore, the decimal value of a Line Feed is 10.

This decimal value can be used in the CHAR(...) function in Google Sheets to return the desired character.

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I added the above for those that need new lines in formulas. The below is a snapshot of Dez's answer for completeness :)

Dez's Answer

 

In Edit Mode

 
  • Windows/Linux: Ctrl + Enter or Alt + Enter
     
  • Mac: Command/option(Alt) + Enter

Amendment

New Line in Cell Formula >> CHAR(10)

Example Usage

  • =Concatenate("Line 1", CHAR(10), "Line 2", CHAR(10), "Line 3")
  • =Join(CHAR(10), "Line 1", "Line 2", "Line 3")

Why CHAR(10)?

A new line is also known as a Line Feed. The hexadecimal Unicode Control Code for a Line Feed is U+000A. Therefore, the decimal value of a Line Feed is 10.

This decimal value can be used in the CHAR(...) function in Google Sheets to return the desired character.

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I added the above for those that need new lines in formulas. The below is a snapshot of Dez's answer for completeness :)

Dez's Answer

In Edit Mode

  • Windows/Linux: Ctrl + Enter or Alt + Enter

  • Mac: Command/option(Alt) + Enter

I changed the formatting of the keys
Source Link
edit approved Jan 11, 2019 at 14:10
simhumileco
edit approved Jan 11, 2019 at 14:10
simhumileco
  • 105
  • 5

Amendment

New Line in Cell Formula >> CHAR(10)

Example Usage

  • =Concatenate("Line 1", CHAR(10), "Line 2", CHAR(10), "Line 3")
  • =Join(CHAR(10), "Line 1", "Line 2", "Line 3")

Why CHAR(10)?

A new line is also known as a Line Feed. The hexadecimal Unicode Control Code for a Line Feed is U+000A. Therefore, the decimal value of a Line Feed is 10.

This decimal value can be used in the CHAR(...) function in Google Sheets to return the desired character.

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I added the above for those that need new lines in formulas. The below is a snapshot of Dez's answer for completeness :)

Dez's Answer

In Edit Mode

  • Windows/Linux: ctrlCtrl + Enter or altAlt + Enter
  • Mac: Command/option(altAlt) + Enter

Amendment

New Line in Cell Formula >> CHAR(10)

Example Usage

  • =Concatenate("Line 1", CHAR(10), "Line 2", CHAR(10), "Line 3")
  • =Join(CHAR(10), "Line 1", "Line 2", "Line 3")

Why CHAR(10)?

A new line is also known as a Line Feed. The hexadecimal Unicode Control Code for a Line Feed is U+000A. Therefore, the decimal value of a Line Feed is 10.

This decimal value can be used in the CHAR(...) function in Google Sheets to return the desired character.

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I added the above for those that need new lines in formulas. The below is a snapshot of Dez's answer for completeness :)

Dez's Answer

In Edit Mode

  • Windows/Linux: ctrl + Enter or alt + Enter
  • Mac: Command/option(alt) + Enter

Amendment

New Line in Cell Formula >> CHAR(10)

Example Usage

  • =Concatenate("Line 1", CHAR(10), "Line 2", CHAR(10), "Line 3")
  • =Join(CHAR(10), "Line 1", "Line 2", "Line 3")

Why CHAR(10)?

A new line is also known as a Line Feed. The hexadecimal Unicode Control Code for a Line Feed is U+000A. Therefore, the decimal value of a Line Feed is 10.

This decimal value can be used in the CHAR(...) function in Google Sheets to return the desired character.

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I added the above for those that need new lines in formulas. The below is a snapshot of Dez's answer for completeness :)

Dez's Answer

In Edit Mode

  • Windows/Linux: Ctrl + Enter or Alt + Enter
  • Mac: Command/option(Alt) + Enter
reformatted question, added second example based on comment, and explained why
Source Link
Christopher Rucinski
Christopher Rucinski
  • 734
  • 5
  • 9

Amendment

New Line in Cell Formula >> CHAR(10)

Example Usage

  • =Concatenate("Line 1", CHAR(10), "Line 2", CHAR(10), "Line 3")
  • =Join(CHAR(10), "Line 1", "Line 2", "Line 3")

Why CHAR(10)?

A new line is also known as a Line Feed. The hexadecimal Unicode Control Code for a Line Feed is U+000A. Therefore, the decimal value of a Line Feed is 10.

This decimal value can be used in the CHAR(...) function in Google Sheets to return the desired character.

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I am added thisthe above for those that need thisnew lines in formulas. The below is a snapshot of Dez's answer for completeness :)

New Line inDez's Answer Cell Formula...

  • Use the formula - CHAR(10)

Example Usage

=Concatenate("This is the first line", CHAR(10), "This is the second line")

Dez's Answer

Note: slight modification

In Edit Mode

  • Windows/Linux: ctrl + Enter or alt + Enter
  • Mac: Command/option(alt) + Enter

Amendment

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I am added this for those that need this answer :)

New Line in Cell Formula...

  • Use the formula - CHAR(10)

Example Usage

=Concatenate("This is the first line", CHAR(10), "This is the second line")

Dez's Answer

Note: slight modification

In Edit Mode

  • Windows/Linux: ctrl + Enter or alt + Enter
  • Mac: Command/option(alt) + Enter

Amendment

New Line in Cell Formula >> CHAR(10)

Example Usage

  • =Concatenate("Line 1", CHAR(10), "Line 2", CHAR(10), "Line 3")
  • =Join(CHAR(10), "Line 1", "Line 2", "Line 3")

Why CHAR(10)?

A new line is also known as a Line Feed. The hexadecimal Unicode Control Code for a Line Feed is U+000A. Therefore, the decimal value of a Line Feed is 10.

This decimal value can be used in the CHAR(...) function in Google Sheets to return the desired character.

Note: Dez's answer does not work for cell formulas. I was searching for adding new-lines in cell formulas, and this StackExchange question popped up. Therefore, I added the above for those that need new lines in formulas. The below is a snapshot of Dez's answer for completeness :)

Dez's Answer

In Edit Mode

  • Windows/Linux: ctrl + Enter or alt + Enter
  • Mac: Command/option(alt) + Enter
replaced http://webapps.stackexchange.com/ with https://webapps.stackexchange.com/
Source Link
Community Bot
Community Bot
  • 1
Source Link
Christopher Rucinski
Christopher Rucinski
  • 734
  • 5
  • 9