The CODE and CHAR Functions

CODE(fexf) and CHAR(miinher) perform opposite functions. CODE returns the numeric code (either Macintosh character codes or ANSI character codes for Windows) for a single character or the first character in a text string, CHAR returns the character corresponding to the character code. For example, CODE( a ) returns 97, CHAR(36) returns.  

CHAR(10) is the line feed character, CHAR(13) is the carriage return (the ll symbol you see when you choose Show SI from the View menu in Microsoft Word). Use one of these characters to insert a line break in text within a formula CHAR(10) in Excel for Windows, CHAR(13) in Excel for the Macintosh. 

If you merely use Wrap Text in Alignment from the Format menu. Excel will decide where to break the text. By using CHAR(10) or CHAR(13), you get to decide where to break the text. 

Excel Tip. The following formula will produce the correct line break character when used in either Excel for Windows or Excel for the Macintosh  

---