Monday, November 10, 2008

New line character in Excel cell

This is really simple, but I didn't know how to do it until just now. 
Everytime when I press the "Enter" key, I'll be brought to the next cell of the Excel.
Until just now, I found out actually there is a way to go to the next line in the same cell.



This is pretty simple, just press Alt & Enter key, that's it! :D

It's called Line Feed character.
In VB, it can be done by calling Chr(10) or vbLf.
e.g. 
"a) Sentence 1" & Chr(10) & "b) Sentence 2" or
"a) Sentence 1" & vbLf & "b) Sentence 2" or

Information extracted from AllExperts site.

No comments:

Post a Comment