Char(10) , ascii for CRLF, Carriage Return, Wrap text in Microsoft Excel 2003

Char(10) means carriage return in Microsoft Excel 2003.

It can be used together with Concatenate function in Excel “&”.  & function is to add text/number together to form a string.

By adding Char(10) in formula, the text will be split.  You have to change the cell format to WRAP text to view the result correctly.

SPAM and Virus prevention by Barracuda Network Solutions   ­­