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 vote348 views1 answer
Add text to combobox drop down vb
VBA
0 vote344 views1 answer
Rotate image by any angle vb.net
VBA
8 votes499 views1 answer
Excel vba make word from bytes
VBA
0 vote330 views1 answer
Vbs send keys
VBA
0 vote348 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote313 views1 answer
Putting marquee in vb.net
VBA
1 vote389 views1 answer
Perform http request in vb.net
VBA
0 vote350 views1 answer
Date as number vb
VBA
22 votes550 views1 answer
Xl vba check for folder
VBA
1 vote336 views1 answer
Vba delete file
VBA