Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Add Outline to Data in Excel
  • Error Bars in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Use Data Form to input, edit and delete records in Excel
  • Subtotal function in Excel

References

  • Merge tables with VLOOKUP in Excel
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Left Lookup in Excel
  • How to get relative column numbers in a range in Excel
  • How to use Excel COLUMN Function

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation date in specific year
  • Excel Data validation specific characters only
  • Data validation must not exist in list
  • How To Create Drop-down List in Excel

Add line break based on OS in Excel

by

To add a line break taking into account the current OS (Mac or Windows), you can use the INFO function to test the system and then return the correct break character — CHAR(10) for Windows, CHAR(13) for Mac.

Note: make sure you have text wrap enabled on cells that contain line breaks.

Formula

=IF(INFO("system")="mac",CHAR(13),CHAR(10))

Explanation

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. This makes it tricky to write a single formula that will work as expected on both platforms.

The solution is to use the INFO function to test the current environment, then adjust the line break character accordingly. We do this by adding this formula to C3:

=IF(INFO("system")="mac",CHAR(13),CHAR(10))

Then we we name C3 “break” so we can use the word break like a variable later. If Excel is running on a Mac, break will equal CHAR(13), if not, break will equal CHAR(10).

In column E, we concatenate the address information that appears in B, C, and D with a formula like this:

=B6&break&C6&break&D6

The result of the concatenation is text with line breaks:

Traci Brown¬
1301 Robinson Court¬
Saginaw, MI 48607

 

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use IFS function in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • IF with wildcards in Excel
  • How to use Excel OR Function
  • How to use Excel NOT Function

Date Time

  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Add days exclude certain days of week in Excel
  • WEEKDAY function: Description, Usage, Syntax, Examples and Explanation
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Group times into unequal buckets in Excel
  • Map inputs to arbitrary values in Excel
  • Running count group by n size in Excel
  • Group numbers at uneven intervals in Excel
  • Group arbitrary text values in Excel

General

  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • How to calculate project complete percentage in Excel
  • Count cells that do not contain errors in Excel
  • How to password protect excel sheet?
  • How to Create Calendar in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning