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 vote312 views1 answer
Excel vba protect content
VBA
5 votes357 views1 answer
Excel-vba get integer high byte
VBA
0 vote302 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote304 views1 answer
Telephon call in vba
VBA
0 vote320 views1 answer
Excel vba remove formatting from cell
VBA
0 vote288 views1 answer
Vbide vbproject reference
VBA
0 vote318 views1 answer
WGET FTP
VBA
0 vote311 views1 answer
Excel vba move down to next visible cell
VBA
0 vote313 views1 answer
Thread sleep vb
VBA
0 vote321 views1 answer
Afficher un message d'erreur vba
VBA