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 vote240 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote240 views1 answer
Excel delete ever other vba
VBA
-1 vote229 views1 answer
Vba code to add new column in table
VBA
0 vote252 views1 answer
Convert number to minutes in vba
VBA
0 vote236 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote256 views1 answer
Selecttoken em vbnet e json
VBA
0 vote224 views1 answer
Vb.net round to 2 decimal places
VBA
1 vote230 views1 answer
Vba declare api 64 bit 32 bit
VBA
1 vote233 views1 answer
Vba delete file
VBA
0 vote250 views1 answer
Regex numeric digits
VBA