Help

Would love some formula help!!

Topic Labels: Formulas
883 2
cancel
Showing results for 
Search instead for 
Did you mean: 
AmyMarie
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!!!!

-Amy

 

 

2 Replies 2
Sho
11 - Venus
11 - Venus

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

https://www.youtube.com/watch?v=5UquU26vzlg

Power Query is that answer to so many data challenges and problems. Whether using it in Power BI, Excel or elsewhere. I love it! This was my solution to a Reddit Forum question 00:00 Intro 00:26 The Question / Challenge 01:36 Split to Rows 03:34 Group By 04:13 Reference a Grouped Column 06:04 An ...

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