How to Reverse First and Last Name and Add Comma Between in Google Sheets
Learn how to reverse first and last names in Google Sheets using a simple formula that adds a comma between them. This tutorial provides a step-by-step guide to automate the process for multiple names effortlessly.
Let's reverse John Doe to Doe John. We can do this for all of these names, a hundred names plus, but we don't wanna do it manually. We wanna do it with a formula . So we're gonna do equal split . Now split is going to take the text here in A two, and we're gonna use a delimiter , which is the thing in between. So that's gonna be the space here. Split that. It's gonna add another column, but. We can already see that the first column of this split is the first name, and the second column of this split is going to be the last name. So we'll wrap index around there, same row, but use column two. Now we just get the last name. Well, we want to add at the end an ampersand, then a. Combine 2 Columns into 1: First Names and Last Names Together 5 Ways to Combine Names in Google Sheets How To Separate First And Last Name In Google Sheets
Quotes and inside the quote, we can do comma and a space. Then another ampersand, and we're going to copy this exact formula and paste it after this other ampersand. Now we have dodo, but we don't want dodo. We want do John. So change this last two to one, meaning the first column of that split , hit enter, and now we have our answer. So now we can copy and paste all the way down, but you see we have some values here. Hashtag value. This is an error because there's nothing to split here. So what we need to do as well, just to make this a little nicer, is add if is blank, a two and two commas at a parentheses at the end. Now copy and paste that all the way down. And we have our formula goes all the way down. Embed Quote and Author to Daily Quote Website How To Calculate ROAS in Google Sheets What is a spreadsheet formula?
But we just don't see anything until we put in a first name or last name, or both first and last name, and we will reverse it and add a comma to each and every one of those names. Hope you enjoyed . 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. Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. When did you learn the secrets of Google Sheets? | Sheet Talking Episode 8 Esa Better Sheets Videos Checklist How To Separate First And Last Name In Google Sheets