00:00In my last video, I demonstrated how to split first and the last name, but someone had asked,
00:05what if my dataset include a middle name, like this dataset here? Awesome question.
00:11Technically, there are two ways to do it. The second one will blow your mind how easy it is.
00:16Let's begin with method 1. To extract the first name, we use a formula that identifies the first
00:20space in the text of cell B3 and retrieve all characters to its left. To extract the last name,
00:26we use another formula that identifies the second space in the text of cell B3 and retrieves all
00:32characters to its right. And finally, to extract the middle name, apply the formula that identifies
00:37the first and the second space in the text of cell B3 and retrieve the characters between them.
00:43After that, apply the same formula for all the rows and you're done. Now in method 2, we'll use space
00:47as a delimiter. First, you're going to select the full name, go to Dara, Dara Tools, Text to Column.
00:53After that, select Delimited and click on Next. You select Space and Next and the destination
01:00is going to be cell C3 and finish.
Comments