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 vote302 views2 answers
VB
VBA
0 vote299 views1 answer
Excel vba set cell value to empty
VBA
0 vote272 views1 answer
Windows Presentation Foundation dark title bar
VBA
8 votes333 views1 answer
Vba make integer
VBA
0 vote285 views1 answer
Send text to clipboard vb.net
VBA
1 vote263 views2 answers
Vba remove first 2 characters from string
VBA
0 vote277 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
18 votes407 views2 answers
Vba make word from bytes
VBA
0 vote290 views1 answer
Vba clear collection
VBA
1 vote288 views1 answer
Vb.net get name by Selection Changed
VBA