Power Query: Extracting Names from an Email List

Here's a quick demo where Power Query (Get and Transform) can help us with the every day things.

The Task

We have a list of email addresses copied from an email

We want to clean up that data for loading into another system

Power Query can do it for us, and now we have a nice file to automate this for evermore into the future.

The Steps

Step 1: Paste your list of email addresses into a cell in Excel

Step 2: Name that cell Data (remember to press Enter)

Step 3: Go to Power Query and choose From Table

Step 4: This is the "magic" part - Split Column into Rows

Right Click in the Column1 > Split Column > By Delimiter

The Trick

- Advanced option Split Into Rows

This is then created

Step 5: Split this into 2 columns based on "<"

Results in...

Step 6: Just some last clean ups...

Right Click Column1.2 Replace ">" with blanks

Then just in case any names have lower case letters lets Capitalize each word

Done.

Home.... Close and Load to Table

Now in future this file can be used whenever this kind of task needs to be done. Just Right Click on the Green Table and click Refresh

Hope that helps someone out and gives a few ideas.

Wyn