How to split full name into first name and last name in excel - Shortcut

In Excel, we can split full name into first name and last name. How to split that see below in step by step manner

Step 1:

Take any excel worksheet which have the data with full name as follows

Step 2:

Write first name and last name of first data in the below given manner

Step 3: 

After that put the cursor in second data first name column and give Ctrl+E   and same way do for the last name  then the result will be:

For more shortcuts follow us....Comment below If you have any doubt