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

20 votes263 views1 answer
Excel vba recursive example factorial function
VBA
4 votes205 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote194 views2 answers
How to concatenate more than 40 lines in vba
VBA
1 vote195 views1 answer
Vba optional
VBA
1 vote192 views1 answer
Excel vba unload userform
VBA
32 votes272 views2 answers
Excel vba column letter
VBA
0 vote192 views1 answer
Refresh token em vb net
VBA
2 votes188 views1 answer
Date format for ms chart vb.net
VBA
-1 vote204 views1 answer
VBA check if a cell contains a letter or string
VBA
2 votes207 views1 answer
Excel vba check if string entirely numeric
VBA