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 vote384 views2 answers
Excel vba store array and write to sheet
VBA
22 votes521 views1 answer
Xl vba check for folder
VBA
0 vote340 views4 answers
Vgrive,deb
VBA
0 vote357 views1 answer
Filesystemobject vba reference
VBA
0 vote330 views1 answer
Find database connection string vb
VBA
0 vote320 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote319 views1 answer
For each item in folder outlook vba
VBA
5 votes353 views1 answer
Excel vba get user selected range
VBA
0 vote311 views1 answer
How to get value from clipboard in vbnet
VBA
1 vote298 views1 answer
Textbox find and replace vb
VBA