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

1 vote202 views1 answer
How to open cmd with vbd
VBA
1 vote240 views2 answers
Vba function return array
VBA
0 vote265 views1 answer
Vba userform textbox wrap text
VBA
0 vote182 views1 answer
Vba set vs dim
VBA
1 vote244 views1 answer
What does vbs stand for
VBA
2 votes223 views1 answer
Date format for ms chart vb.net
VBA
1 vote227 views1 answer
Vba optional
VBA
0 vote212 views1 answer
Excel autofilter vba
VBA
0 vote245 views1 answer
VBA Sleep Snippet
VBA
0 vote253 views1 answer
Vba search string position
VBA