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 vote227 views1 answer
Vba pass named range to function
VBA
0 vote246 views1 answer
Regex numeric digits
VBA
1 vote238 views1 answer
Add control vb
VBA
0 vote263 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote246 views1 answer
Vba word pdf table to excel
VBA
0 vote229 views1 answer
Change form background image vb
VBA
0 vote270 views1 answer
Vbs run with cscript
VBA
0 vote248 views1 answer
Excel vba first working day month
VBA
0 vote258 views2 answers
Vb.net include quotes in string
VBA
27 votes313 views2 answers
Vba check if file exists
VBA