https://youtube.com/watch?v=FUKXR4aXY_4Learn how to separate first name and last names. METHOD 1: Using Ctrl + E Here are the steps. 1) Enter first name. 2) Go to any cell below that…