That tells Excel to insert the character numbered as 10 in the computer's character set, which on Windows is a line break character. If you're using a MacOS computer, use the number 13 rather than ...

Excel controls the number of lines in such a block using the line-feed character, "CHAR(10)." Visual Basic for Applications, also called VBA, can count line numbers by counting the number of line ...