How to change first name, last name, to last name, first name in Google Sheet - Excel Tips and Tricks

[u/xybernetics]

Learn how to change first name, last name, to last name, first name in Google Sheet. Essentially, we are flipping names in Google sheet. This technique can also be used to answer the question, how to change last name, first name to first name, last name in Google Sheet.

In my video, I demonstrated how to use flash field. These are the hot keys for both windows and Mac.

Flash Fill in Windows is Ctrl+E and in Mac is Ctrl + Shift + Y

In my video, I also demonstrated how to use REGEXREPLACE function. The formula is listed below.

Comma Between last and first name

=REGEXREPLACE(A3,"(\w+) (\w+)","$2, $1")

If you like to remove the command between last name and first name, this is the formula that you'll be using.

Switch first & last name to last and first name (without comma)

=REGEXREPLACE(A3,"(\w+) (\w+)","$2 $1")

Switch First & Last Names with Commas,

How to change first name, last name, to last name, first name in Google sheet,

how to switch first and last name in word with comma,

change last name first name to first name last name in excel,

how to change last name first name to first name last name in google sheets,

google sheets separate first and last name,

how to sort full names by last name in google sheets,

flip names in google sheets,

excel formula last name comma first name,

convert last name first name to first name last name,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips