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 vote304 views1 answer
Vbnet click on dgv cells
VBA
3 votes310 views1 answer
Excel insert blank row for value change in column
VBA
0 vote325 views1 answer
Vba ternary
VBA
31 votes426 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote296 views1 answer
Get current url vb.net
VBA
0 vote294 views1 answer
Vbnet line graph smooth lines
VBA
22 votes430 views1 answer
Excel vba check if directory exists
VBA
0 vote289 views1 answer
Vlookup columns not next to each other
VBA
0 vote299 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
1 vote301 views1 answer
Excel vba force recalculation
VBA