Surprising: Split Outlook Distribution List In Excel – 2282




About this tutorial:

Video duration: 4:49
Kim has a distribution list in Outlook with 130+ names. She wants those names in Excel. When she copies and pastes, everything ends up in a single cell.

In this episode, a simple set of steps to split the distribution list into rows and then columns for Name and E-Mail address.

These steps won’t (yet) work on a Mac. You are using the Get & Transform tools (also known as Power Query) on the Windows version of Excel.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

17 thoughts on “Surprising: Split Outlook Distribution List In Excel – 2282

    jacketz1

    (June 12, 2019 - 9:01 am)

    Great solution. How do you inserted new entire row without mouse at 0:40?

    MAJID SIDDIQUE

    (June 12, 2019 - 9:01 am)

    Great Boss

    Keisha Clark

    (June 12, 2019 - 9:01 am)

    Power query is so neat. Clean a certain data set once and refresh the next time. Love it. 😊

    Qadeer Ahmed

    (June 12, 2019 - 9:01 am)

    Awesome

    steve simpson

    (June 12, 2019 - 9:01 am)

    if you have something to eat before posting you wouldn't need to eat the microphone 😉 great tips though

    Learn Excel

    (June 12, 2019 - 9:01 am)

    Beautifull Example!

    Ogwal Francis

    (June 12, 2019 - 9:01 am)

    Thank Mr Excel

    Thanks Bill, You could also use column from example after split data to rows, it doesn't need to replace space and also it is shorter way.
    In your way if some of Email doesn't have name, Email will come to name column.

    success 555

    (June 12, 2019 - 9:01 am)

    Very GOOD PARTNER. #Success555

    MF Wong

    (June 12, 2019 - 9:01 am)

    Power Query rocks!
    Indeed, I also did that occasionally. Because the frequency of doing so is really small, i did it in a quick and dirty way:
    1) Separate the items by using Text to Column
    2) Copy the items in rows and paste special, Transpose
    3) Get the Name and Email by Flash Fill
    Cheers,

    CA.Lakshmi Narayan Reddy Jambula

    (June 12, 2019 - 9:01 am)

    Awesome trick. Thanks for sharing.

    Matt Schoular

    (June 12, 2019 - 9:01 am)

    I love it.. Thanks Mr.Excel

    Wayne Edmondson

    (June 12, 2019 - 9:01 am)

    Hi Mr. Excel.. cool trick. Thanks for the PQ magic. Thumbs up!

    Diego Lozano

    (June 12, 2019 - 9:01 am)

    Please make a tutorial for get information od web site using visial basic, that would be great

    Diego Lozano

    (June 12, 2019 - 9:01 am)

    Your the besy

    karthik karthik

    (June 12, 2019 - 9:01 am)

    Long process. Instead paste data horizontal/vertical and use flash fill

    ExcelIsFun

    (June 12, 2019 - 9:01 am)

    Power Query is rad to the max!!!! BTW, why did you replace "; " with ";"?

Leave a Reply

Your email address will not be published. Required fields are marked *