Contact Column shows as email addresses, but I need to extract the First & Last Names
Okay so the title is a bit confusing, but here's the issue:
I have a sheet where I need to collect emails so I can send update requests, alerts, all that jazz. Through a form, people input their email addresses into Column 1.
Then, using the function =[Column1]@row] in a Contact Column named Column 2, all of the data in Column 2 shows up as Contact values, and it only displays their emails. I hover over the contact bubble, and it shows me their name, work number, etc., but on the sheet, only their email is displayed. This is done for automation purposes. This is fine. I don't mind this, and I'd rather not change it.
The problem is that when I generate documents, and I try to use the contact data from Column 2, it populates the fields in the documents as emails. I don't want emails. I want their first and last names.
Ideally, I'm willing to implement a third (or however many), supporting column that converts the Contact data from Column 2 into regular text data displaying just the individual's First and Last Name.
Note: the emails are formatted as "[email protected]" and I cannot extract the names from the email address itself.
Help Article Resources
Check out the Formula Handbook template!