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

2 votes118 views1 answer
Excel vba pause
VBA
5 votes181 views1 answer
Excel vba low word from Long Integer
VBA
0 vote180 views1 answer
Return na vba
VBA
0 vote173 views1 answer
Excel R1C1 mode
VBA
0 vote169 views1 answer
Excel vba clear filter
VBA
0 vote170 views1 answer
Vba compare strings
VBA
1 vote161 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote180 views1 answer
Default host vbox address
VBA
1 vote161 views1 answer
Textbox find and replace vb
VBA
0 vote164 views1 answer
Type excel.application is not defined vb
VBA