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 vote239 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote270 views1 answer
Vbnet add axis labels to chart
VBA
1 vote232 views1 answer
Vbscript convert ascii code to character
VBA
0 vote225 views1 answer
Excel vba disable mouse click
VBA
0 vote225 views1 answer
Vba sheet visible
VBA
1 vote216 views1 answer
Vba compile error object required
VBA
0 vote228 views1 answer
Excel vba copy entire sheet paste values
VBA
8 votes323 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote216 views2 answers
Excel vba prevent save
VBA
0 vote257 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA