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 vote158 views1 answer
Vbnet revrese the order of character in string
VBA
9 votes278 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote143 views1 answer
Vbnet line graph smooth lines
VBA
0 vote159 views1 answer
VBA Sort RossetaCode
VBA
0 vote142 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote148 views1 answer
Check range is in another range vba
VBA
3 votes146 views1 answer
Extract the nth word from a text string
VBA
0 vote148 views1 answer
Vba apostrophe chr
VBA
0 vote157 views1 answer
Vba simple quote
VBA
0 vote138 views1 answer
Vba test optional argument
VBA