How to Separate First and Last Names in Microsoft Excel

Have you got a list of full names that need to be divided into first and last names in separate columns? It’s easy to do that, thanks to Microsoft Excel’s built-in options. We’ll show you how to perform that separation.



Chapters:
0:00 Intro
0:23 How to split first and last names into different columns
1:20 Separate and last names with middle names
2:07 End screen



What you’ll learn:
1. How to Split First and Last Names Into Different Columns
a. How to use Excel’s Text to Columns method
b. How to separate the first and last names
2. Separate First and Last Names With Middle Names
a. How to use Excel’s Flash Fill feature to quickly separate the first and last name
















Song: INOSSI – Nightfall
Music provided by Vlog No Copyright Music.
Creative Commons – Attribution 3.0 Unported
Video Link: https://youtu.be/by6T7YHpbc4

#computereverywhere #howto #separate #firstandlast #names #microsoftexcel