So you might want to get the last name in a cell or the last word in a cell, no matter what. Uh, what we usually do, and what I've usually said in the past is use some kind of index around split . Now I'm gonna show you a different way, uh, because if we split this, if we have a full name, like a first and last name, it works fine. We just look for the second. But when we have a middle name or. Any number of middle names or any number of words, and we just wanna get the right most word. Then I'm gonna show you a different way. So we will use split . We're gonna split this by the spaces and when the, the eliminator is a two quotes with a space. That's it. We're gonna say yes, split by each, and it's going to give us a reference

error if we have something in. This C two, we can insert a few columns and we can see that this split is just sort of taking each word and putting it separately. So how do we make sure we're only gonna get the right most word? And I'll show you right now, we're gonna wrap this with choose calls. So choose calls means choose the column. So here's the whole array and we've split it up into different columns. Now how do we get the right most one? We can put a number here. One, that's the first one. Put a two, that's the second one. Put a three. But how do we know how many there are? Well, we can just do negative one and it's gonna start from the right side and count the first one. Now, if we did negative two, it'll be the second from the right.

But negative one is gonna get us the right most word in the cell. There you go. And we can copy and paste that all the way down. We can get the exact last name, no matter how many words or how many names are in that cell. I. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.