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 vote259 views1 answer
Excel vba arrondir
VBA
0 vote293 views1 answer
Vbnet find highest value in chart
VBA
0 vote277 views1 answer
Excel vba extract year
VBA
0 vote317 views1 answer
Sort dictionary by key vba
VBA
0 vote289 views1 answer
Select case vba
VBA
0 vote332 views1 answer
Vba userform textbox wrap text
VBA
0 vote290 views1 answer
Excel protect cells with formulas
VBA
1 vote258 views1 answer
How to open cmd with vbd
VBA
0 vote290 views1 answer
.net dark title bar
VBA
0 vote309 views1 answer
Add text to Shape VBA
VBA