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 vote176 views1 answer
Type excel.application is not defined vb
VBA
0 vote187 views1 answer
Group controls programmatically vb
VBA
0 vote184 views1 answer
Vba check if class implements interface
VBA
0 vote173 views1 answer
String contins in vba
VBA
0 vote164 views1 answer
Remove first character from string vb
VBA
0 vote188 views1 answer
Vba open report
VBA
5 votes197 views1 answer
Excel vba first byte from INTEGER
VBA
1 vote178 views2 answers
Get all column names from excel vba
VBA
0 vote185 views2 answers
Vb.net include quotes in string
VBA
0 vote171 views1 answer
Excel vba hide gridlines
VBA