You will now see the name extracted from the email address, properly formatted as well!
5. Apply the Formula to Entire Column
In order to extract the domain from all of the emails in the column there are two methods you can follow:
Click on the cell and double-click the round blue dot to autofill the column with the formula.
Click on the cell and Click-drag the round blue dot in the lower-right corner of the cell.
Either way, the results will be the same:
Name extracted from email address
You have now successfully extracted a name from an email in Google Sheets!
What if the last name comes first instead of the first name?
The last name appearing first before the first name in email addresses are less common, but the solution can be pretty straightforward: instead of a space, we insert a comma to denote that the last name comes first. The formula can be modified to: