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 vote231 views1 answer
Excel vba prevent saving workbook
VBA
20 votes531 views1 answer
Excel vba factorial
VBA
0 vote230 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote211 views1 answer
Excel vba remove formatting from cell
VBA
0 vote226 views1 answer
Vba format currency
VBA
0 vote232 views2 answers
Excel vba number format file size
VBA
0 vote217 views1 answer
Vba sheet visible
VBA
5 votes245 views1 answer
Excel vba left word from Long Integer
VBA
0 vote230 views2 answers
Open url from vba
VBA
0 vote219 views1 answer
Excel vba existence of a file
VBA