How to Insert New Line (Line Feed) character in Excel

Pressing Alt + Enter inserts what is called a Line Feed character, which inserts a new line. There other ways to insert the Line Feed character in VB.

The first is by adding character number 10:
“Line 1″ & Chr(10) & “Line 2″

The second is by adding the command vbLf:
“Line 1″ & vbLf & “Line 2″

Example with new line:

Excel New Line Feed

Excel New Line Feed


About onlinejt

Blogger

No comments yet.

Leave a Reply


*