Would love some formula help!!

Topic Labels: Formulas
506 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I received some contact info (Excel format) from another source that I'd love to incorporate into my Airtable. It's over 1000 records. There are two columns. The first column is fine as is.

The 2nd column lists a person's name and email in this format: 

First name Last name (email address)

It's complicated by the fact that many of the fields in that column have 2 or sometimes 3 people, so it's listed like this within the field:  

First name Last Name (Email), First name Last name (Email)

And sometimes even 3 people, like this: 

First name Last Name (Email), First name Last name (Email), First name Last name (Email)

Help!!! Thank you!!!!




2 Replies 2
11 - Venus
11 - Venus

I think this is better processed in an Excel power query.
I found this instructional video.

Hmm, do you have any commas in your names?  If you don't, I would try the following:
1. Create a new table called "Contacts"
2. Create a linked field from that table to your imported data table
3. Copy all the values from the second column and paste them into the linked field

This should create one record per person

After that, we go to the "Contacts" table and use formulas to split out the first name, last name, and emails into different fields