#Excel command for new line mac mac os

If the spreadsheet is likely to be used on another operating system, we can use the INFO function to determine which operating system is running.Īs an example, the line break character is different on Windows and Mac: With each operating system having its own character set, it makes the translation between Excel versions a little tricky. Then you’ll be able to work along with examples and see the solution in action, plus the file will be useful for future reference.ĭownload the file: 0045 CHAR function in Excel.xlsx I recommend you download the example file for this post. We’ll look at each of these as examples later in this post.

combined with SUBSTITUTE to remove non-printed characters.

The CHAR function in Excel returns the character associated with each code. Those characters can be letters, numbers, punctuation, symbols, and even characters that are not displayed (such as line breaks).Įvery character in the set has a code. The character set contains the primary printed and non-printed characters available on a computer.

Excel online has a limited version of the Windows character set.

#Excel command for new line mac mac os

Mac uses the Mac OS Roman character set.Windows has the Windows -1251 character set, which is more commonly known as ANSI.

The CHAR function in Excel returns a specific character based on a code number from the operating system’s character set.Įach operating system has it’s own character set: