Convert "First Name Last Name" to "Last Name, First Name" in Excel Using Flash Fill (Solution #2)

This video provides a brief tutorial showing how to use Excel's FLASH FILL feature to quickly and easily convert cells from a "First Name Last Name" format to a "Last Name, First Name" format. FLASH FILL is awesome! It's like magic! This strategy is Solution #2.

In a previous video, I shared Solution #1 by showing how to use Excel's TEXT-TO-COLUMNS feature along with the CONCAT function to convert cells from a "First Name Last Name" format to a "Last Name, First Name" format. It's one of my most popular videos! You'll find it here: Convert “First Name Last Name” to “La...

I have a series of Excel spreadsheet tutorials posted on my channel. I post new videos periodically, so subscribe to my channel to become an Excel aficionado. Once you learn more about Excel, you’ll be hooked! I promise you! Here's a link to the tutorial playlist: https://bit.ly/3usMvMl

#FrankMLoSchiavo #ExcelAficionado

The Frank Show Starring Frank M. LoSchiavo features educational videos packed with lots of great information! Like an old-fashioned general store, my channel has something for everybody. Many of my videos feature lectures on statistics and psychology, but there are bonus videos on a variety of other topics, so subscribe today and join the fun!

SUBSCRIBE: frankmloschiavo

MY FACULTY WEBPAGE: http://bit.ly/faculty-webpage-FML

MY GOOGLE SCHOLAR PROFILE: http://bit.ly/google-scholar-FML

SUPPORT MY CHANNEL: If you find my videos helpful, please like them, share them, and tell all your friends to check out my channel!

* CONSIDER A VENMO DONATION: @Frank-M-LoSchiavo
* CONSIDER A PAYPAL DONATION: http://bit.ly/paypal-FML

• #education
• #microsoft_excel
• #flash_fill
• #concatenate_function
• #concat_function
• #text_to_columns