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 vote208 views1 answer
Add items to combobox vb.net
VBA
0 vote232 views1 answer
Vba add shape oval
VBA
3 votes239 views1 answer
Extract word in a text in excel
VBA
0 vote240 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote229 views1 answer
Excel vba unmerge sheet
VBA
0 vote220 views1 answer
Vbs expand env var
VBA
0 vote221 views1 answer
Return na vba
VBA
0 vote235 views1 answer
Vba file chooser
VBA
0 vote232 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote255 views2 answers
Excel vba number format file size
VBA