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 vote189 views1 answer
Vba find last column in a row with data
VBA
0 vote176 views1 answer
Internet explorer reference vba
VBA
0 vote200 views1 answer
Excel web scraping
VBA
3 votes168 views1 answer
Excel vba last row in range
VBA
0 vote194 views3 answers
Write to text file vb.net
VBA
0 vote199 views1 answer
Ribbon show/hide
VBA
0 vote186 views1 answer
How to format a textbox as date vb net
VBA
18 votes259 views3 answers
Excel-vba make integer
VBA
6 votes185 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote180 views1 answer
Excel vba move down to next visible cell
VBA