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 vote371 views1 answer
Excel vba StartUpPosition
VBA
0 vote369 views1 answer
Vba type
VBA
0 vote369 views1 answer
Vbnet click on dgv cells
VBA
0 vote389 views1 answer
Excel vba disable screen update
VBA
5 votes408 views1 answer
Excel vba left word from Long Integer
VBA
0 vote385 views1 answer
Vbnet check if string is only letters
VBA
3 votes354 views1 answer
Excel vba read registry key value
VBA
0 vote375 views1 answer
VBA Loop to range
VBA
5 votes393 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote372 views1 answer
Vbscript Trim
VBA