Excel Formulas to Add a Line Break Based on the Current OS ~ Quickly!!

Dealing with the text in Excel can be painful as the formatting is limited within Excel cells. One method of organizing text is to add line breaks. In this article, we’ll explore ways of dealing with add a line break based on the current OS in Excel. Let’s get into this article!!

The character used for line breaks is different depending on whether Excel is running on Mac or Windows. CHAR(10) for Windows, CHAR(13) for Mac. Here we will guide you to find the correct character for your OS. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

  • If you want to add a line break taking into account the current OS, use the below formula.

=IF(INFO(“system”)=”mac”,CHAR(13),CHAR(10))

Syntax Explanations:

  • IF – This function helps to return one value for a TRUE result, and another for a FALSE result. Read more on the IF function.
  • INFO – The Excel INFO function returns information about the current operating environment.
  • CHAR – In Excel, the CHAR Function refers to the letters used in a word or a text string.
  • Text – It represents the input text values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

  • First, we will enter the input values in Column B , Column C , and Column D.
  • Now we have to join these text values with a line break based on the current OS.
  • Type the above-given formula in Cell C2 to find the Character value for your current OS.

Conclusion:

From this tutorial, you can get some ideas to add a line break with a formula based on a current OS in Excel. I hope that this article is helpful. Mention your queries in the comment box below.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Also:

15