Can I derive a name from an email address?

Andrea Zenner

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

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)

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. 👍️