00:00This is how you split text with line breaks in Excel.
00:02In my previous video, I demonstrated how to convert this raw data set into this tabular
00:07format using text to column function.
00:10But that method has a bit of limitation when your data set starts to grow.
00:14The more appropriate approach would be to use text split function.
00:18Please keep in mind that the text split function is only available in Microsoft 365 or newer
00:24version of Excel.
00:25Let's start off by deleting our old data set from our table here and place your cursor
00:30on cell D5 here.
00:32Well, we're going to say equal text split open parenthesis.
00:38The first argument will be the cell where your raw data is, comma.
00:42The second argument is your delimiter or how you're going to split the text if you look
00:47at it.
00:47It's basically a line break or a new line.
00:50In ASCII character or in ASCII numeric value, the line break is identified as numeric 10.
00:56If you look at the ASCII chart on the screenshot here, numeric 10 represents line feed, which
01:01is also known as line break here.
01:03That's why this numeric 10 has to be placed here.
01:06Close parenthesis and hit enter will convert this raw data into this line.
01:11Now to apply the same formula right across, just drag your line fill handler here all the
01:16way down to the very last record.
01:17And then there you go, job done.
