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 vote327 views2 answers
Excel vba protect cells with formula
VBA
1 vote308 views1 answer
Excel vba hide zero values
VBA
1 vote316 views1 answer
Highlight selected cell in excel vba
VBA
0 vote315 views1 answer
Check range is in another range vba
VBA
0 vote315 views1 answer
Vba file size
VBA
5 votes371 views1 answer
Excel vba left word from Long Integer
VBA
0 vote328 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote333 views1 answer
.net dark title bar
VBA
0 vote369 views1 answer
Excel web scraping
VBA
0 vote306 views1 answer
Excel vba disable copy paste
VBA