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

1 vote293 views1 answer
How to put a gridpain in a vbox
VBA
0 vote267 views1 answer
Excel vba range contains
VBA
8 votes316 views1 answer
Excel vba make integer
VBA
0 vote249 views1 answer
Enter into cells data grid view
VBA
0 vote262 views1 answer
Vba word open document read only
VBA
0 vote288 views1 answer
Excel vba urlmon
VBA
0 vote274 views1 answer
Vba copy file
VBA
0 vote286 views1 answer
Vba is integer
VBA
0 vote269 views1 answer
Vba len variant
VBA
0 vote301 views1 answer
Move bindingnavigator vb
VBA