Excel text to columns line break

Click on the Data tab, then Text to Columns.
Choose a delimited format, 
choose Other as the delimiter 
Press CTRL and J on the keyboard at the same time. 
This makes your delimited a line break (similar to ALT + ENTER) in excel 
so that each line break that is found is used as the delimiter in your data

Source: support.cyriouswiki.com

Similar codes

0 vote215 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote177 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote206 views1 answer
Excel vba concatenate range
VBA
1 vote245 views1 answer
What does vbs stand for
VBA
0 vote247 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote246 views1 answer
Excel vba clear filter
VBA
1 vote230 views1 answer
Excel vba close form escape key
VBA
0 vote248 views1 answer
Excel vba copy range with filter
VBA
-1 vote221 views2 answers
How close excel through visual basic
VBA
0 vote245 views1 answer
Send text to clipboard vb.net
VBA