Is there a way to create a quick name for an email address on excel spreadsheetsÉ?
I have to change 15,000 e-mail addresses with unknown names and basically guess what the name is. It's easy but incredibly repetitive. Basically I have to take an address like [email protected] and turn it into:
First Name: P
Last Name Sherm
I was just wondering if there is a quicker way of doing this?
More Questions From This User See All
Answers & Comments
Verified answer
If it's consistent where the first letter will be the first name, simply use:
=LEFT(A1, 1)
As for the last name, use this:
=MID(A1,2,FIND("@",A1,1)-2)
This returns the text starting from the 2nd character up to the last character before the @ symbol.