00:00this is how you split text with line breaks in excel and make it look something like this you
00:06start off with you're going to select your raw column like this which is in column b for me and
00:11scroll all the way up again one more time and then after that from your ribbon you're going to select
00:14data and under data tools you're going to select text to column here and then this text to column
00:22pop-up window will appear make sure you select a delimited checkbox here and then click on next
00:28after that on the delimiter section you're going to remove all the delimiter characters
00:32and place a check on the others like this and on this text box here you're going to select the
00:39text
00:39box and press ctrl j to denote new line or line break and you can see that when you do
00:47that uh
00:47blinking pixels should be showing up on your uh this text box here you can't really see it very
00:54well on this video but uh if you look at your data preview it looks like this is what you're
00:59gonna
00:59get now because you're gonna press next here and then on the destination let's get rid of whatever's
01:05in there right now and then press this button on the side here and then select the very first
01:10row on your data set here mine's gonna be d5 and then press enter and then after that all you
01:18have to
01:19do is click on finish and that's how you split text with line breaks but at this point let me
01:25ask you this question can you think of another two ways to do the same thing in excel leave your
01:29answer in the comment section below
