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 vote226 views4 answers
How to continue formula in below line in vba code
VBA
0 vote199 views1 answer
Vba exit while
VBA
0 vote239 views2 answers
Excel vba number format file size
VBA
0 vote209 views1 answer
How to make a a msgbpx in vbs
VBA
6 votes207 views1 answer
Excel vba get the path of current workbook
VBA
0 vote266 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote213 views1 answer
Vb get ip address
VBA
0 vote211 views1 answer
Check if cell is dbnullvb.net
VBA
3 votes214 views1 answer
Extract the nth word from a text string
VBA
1 vote210 views1 answer
Excel vba get ordinal number from cardinal number
VBA