Hi everyone
I have a list of email addresses and I need a formula to extract the name and surname from the email address in a separate column. I have shown the ideal output below, but I have typed the name and surname manually in my example below. I have thousands of rows of emails, so this isn't a viable approach. Ideally I want to achieve all these steps of splitting out the first and surname, removing the unwanted characters and the replacing the . with a space all in one formula, as opposed to splitting in two columns and then concatenating in a third. Is this possible? I use Excel 365. Thank you in advance.
I have a list of email addresses and I need a formula to extract the name and surname from the email address in a separate column. I have shown the ideal output below, but I have typed the name and surname manually in my example below. I have thousands of rows of emails, so this isn't a viable approach. Ideally I want to achieve all these steps of splitting out the first and surname, removing the unwanted characters and the replacing the . with a space all in one formula, as opposed to splitting in two columns and then concatenating in a third. Is this possible? I use Excel 365. Thank you in advance.
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Name | |||
2 | joe.bloggs88@email.com | Joe Bloggs | ||
3 | amy.jones15@email.com | Amy Jones | ||
4 | matt.smith22@email.com | Matt Smith | ||
5 | laura.samson58@email.com | Laura Samson | ||
6 | joe.bloggs88@email.com | Joe Bloggs | ||
7 | joe.bloggs88@email.com | Joe Bloggs | ||
8 | matt.smith22@email.com | Matt Smith | ||
9 | matt.smith22@email.com | Matt Smith | ||
Sheet1 |