Can I derive a name from an email address?

I have a sheet that has a person's name as my primary column and their email address in a contact list column. I have them filling out a form with both pieces of information and people would really only enter one or the other. I need the email address to send notifications and I need the name so they look nice on the calendar on which they are used.

I tried this formula to parse a name from the email, but I get an Invalid Operation error and I can't find where my syntax is incorrect.

=UPPER(LEFT([Email Address]@row, 1)) + MID([Email Address]@row, 2, FIND(".", [Email Address]@row) - 2) + " " + UPPER(MID([Email Address]@row, FIND(".", [Email Address]@row) + 1, 1)) + MID([Email Address]@row, FIND(".", [Email Address]@row) + 2, (FIND("@", [Email Address]@row) - FIND(".", [Email Address]@row)) - 2)

Thanks much!

Andrea

Find more posts tagged with

Accepted answers

Paul Newcome

Try something like this then...

=UPPER(LEFT([Email Address]@row)) + " " + UPPER(MID([Email Address]@row, 2, 1) + MID([Email Address]@row, 3, FIND("@", [Email Address]@row) - 3)

All comments

Paul Newcome

What is the syntax of the email addresses?

Andrea Zenner

@paul Newcome (first initial)(last name)@domain. So mine would be azenner@harmoninc.com.

Thanks!

Paul Newcome

And how exactly would you want the name output based on the email?

"A Zenner"

"A. Zenner"

other?

Andrea Zenner

@Paul Newcome A Zenner would be perfect!

Paul Newcome

Try something like this then...

=UPPER(LEFT([Email Address]@row)) + " " + UPPER(MID([Email Address]@row, 2, 1) + MID([Email Address]@row, 3, FIND("@", [Email Address]@row) - 3)

Andrea Zenner

@Paul Newcome That works! Thanks so much!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.