Hi AT community!
Is there a way to extract a persons name from an email address? I have a form that requestors fill in that automatically creates a record. In the form it asks for an email address, and there’s another column for their name.
If column A has the email address they entered, I’d like column B to hold their name.
Also, all company emails follow a pattern of: firstname.lastname@example.org
How can I add “fname lname” into column B? I just need what’s before the dot, and after the dot with a space in between.
You can use a formula field to extract the parts of the email address. However, note that that would not appear in the form itself. The formula field would be a different field from the field in the form used to enter the name.
There are many different possible formula fields. Here is one that uses regular expressions.