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

15 votes269 views2 answers
Xl vba dynamic string array
VBA
2 votes134 views1 answer
Vba uppercase first letter of each word
VBA
0 vote165 views1 answer
Vba random number
VBA
0 vote143 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote177 views1 answer
Check if cell is dbnullvb.net
VBA
2 votes99 views1 answer
Excel vba pause
VBA
0 vote187 views1 answer
Vba ternary
VBA
1 vote144 views1 answer
Random number generator vb.net
VBA
4 votes137 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote154 views1 answer
Return na vba
VBA