Grabbing email strings

Hi kbudzynski, 

You can create a Calculated Column with the following. Just change your Table and Column name 🙂

Where there is more than one email in a single text string, I'd recommend using Power Query to split up the strings so that the Calculated Column doesn't return an error, then repeat the process accordingly.

All the best! 🙂

Just in case screen shot is blurry, below is the Calculated Column:

In the query editor, you can use the Text.Split function to make a list of all the strings, using the space " " as the delimiter, and then list List.Select to keep only the list items that Text.Contain the "@" symbol.  From there, you can expand that list to new rows, or use Text.Combine to re-concatenate the email addresses with ";" or another delimiter.

Pat