Copy email addresses from Outlook to Excel & separate name and address 

Buy us a coffee ( ☕ ) if we have saved you time via the Super Thanks. Makes it easier to keep these tips coming every day!

This page is the only reason I'm still employed. THANK YOU!!!!!!

This is how you do it! No fluff or being too verbose. Right to the facts! I love it.

I honestly do not know why ppl dislike this video, it must be not what they're looking for... This 2 mins video is so very helpful when I have to add 130 ppl to the new Yammer group I just created, thanks

Thank you so much for taking the time to do this demo; it saved me a lot of time and it was a straight forward explanation. I appreciate this very much. Thank you!!

Exactly what I needed!

YOU SAVED MY NIGHT! Thank you so much for posting this, I have been managing email campaigns and in all of the sudden needed to convert emails into data on an excel sheet to manage it and this was a life saver. I wanna thank you SO VERY MUCH for taking the time to create this vid.

This is such a great tutorial. I used it a year ago (and of course forgot in the meantime) and am so happy I found it again (this time I bookmarked it!) Thanks for not using dorky music, loud voice or other theatrics.

OMG, YOU SAVED HOURS OF MY WORK, i have been researching and researching and this video nailed it!!!!!! thank you so muchhhhhhhhhh

holy hell - this is the most helpful excel video ever!!! sharing with my entire office

No kidding, you didn't waste time at the start of the video and you just saved me a TON of time!

OMG you saved my life. I had 700 emails that needed to be moved to and Excel list. Thank you!

You are a LIFE SAVER! Thank you so much (from a corporate summer intern) :)

oh my goodness, thanks. Explained so simply and SUCCINTLY :) (not like our cousins from over the pond)... "No Janice, I do NOT want to know your life history" ;()

Thank you so much for this simple and quick explanation. Saved me a lot of time!!!! Literally saved my day 🤩

Incredible. Had no idea this was possible but thought, why not check the internet, and there it was. Thank you thank you.

Wow you have saved me so much work. Thank you 😀what a relief to get things done so quick !

You saved me a ton of time, thank you for sharing. Excel is so powerful, if you know how to use it!

10/10 just saved me an hour of copy pasting ty!

Thank you for posting this! The other import & export methods were not doing the job.

omg thank you so much you saved me years of my life with this tactic

This was so good. Thank you for doing this - looking for that "coffee" link!

Excellent VIDEO!!! You saved me LOTS of time, thank you.

This has saved me so much time! Thank you!

Saved me 10 hours! Thank you!!!

This just saved me about 3 hours! TYVM!

Thank you. This is very very helpful and saved me tons of times.

Mate you're a lifesaver

This was just what I needed! Thank you SO MUCH.

This is an excellent concise tutorial. Thank you for this helpful guide!

Thank you! Your video is to the point, clear and easy to follow.

Thanks for your advise, clear and concise :)

Wowwww im so happy u posted this!!!

Saved my life today, thank you!

Thank you so much for sharing ! Saved me so much time !!

For Mac user, you can click control + E, shortcut for Flash Fill

Thaaaaaaanks! This is my favorite so far😃 used it lots of times already!

Thank you so much! This saved me so much time in a stressful situation.

wow, loved this tutorial!! Saved me hours. Thank you!!

amazing you just saved me hours of manual work lol thanks!

Thank you, so very helpful, and so easy to follow

Excellent tutorial. Worked perfectly. Thank you.

thanks much. helped saved a lot of time. simple steps but wow.

This was super helpful. Thank you for sharing.

Very helpful and straight to the point! Thank you!

Saved me hours! Thank you!!!!!!!!

Exactly what I needed. God bless.

Great help. Many thanks for this.

Wow, thanks for that great video which saved me hours of work!

Fantastic. Thanks sooo much! you're a legend

Amazing brilliant, thank you so much for sharing your skills

Excellent video. However, "Text to Columns" is greyed out when I attempt the procedure outlined in your video. Something about "overlapping columns," though all the email addresses are in one column as per your example. Help!

oh, YOU ARE THE BEST !!!!!!!!!! I love youuuu 🥰

Thank you very much! Straight to the point!

Thank you! Great explanation and demonstration.

THANK YOU! Very helpful

This was super helpful dude

Thank you!! This was so helpful.

lifesaver! Thank you for the simplicity.

Thank you for this useful tutorial!

Wow! What a time saver!! Thank you!

Crystal clear thanks :)

WOW, Thank you sooooo incredibly much.

Thank you so much this really helped me!

super easy thank you!

Very helpful - thank you

This really helped. Thanks

Excellent video. Thank you

Realy helpfull, thanks man

You are the best! Thank you thank you

omg! this just helped me a lot!!

Loved it. Thanks

very helpful. thanks

amazing! THANKYOU!

You're awesome! Thanks

Awesome! Thanks so much.

Thank you! Super helpful.

Brilliant video 👍🏻

Amazing thank you so much!

Thank you sooooooooo much!!

Thank you Sir

Thank you! so much helpful :-)

Thank you for sharing this!!!!

Perfect! Thank you so much for the assist.

thanks it works well for me, thank you

You da man, subscribed.

Thanks!

Thanks so much , useful

Fantastic!

Thank you!

Amazing, amazing, amazing! Saved me hours of administration

Thank you boss.

Thank you.

When I try to paste the email addresses into the excel sheet, they won't all go in that 1st cell (A1). They end up pasting as each address in its own column. I have over 100 addresses, so its 100 columns wide and because of this, the Text to Column function won't work (greyed out). Is there a special shortcut that will let me paste my email addresses into that one column (A1)?

Thank you so much

Thank you!!!!

GREAT! Thank you!

Super, thank you so much.

Can you do this in Google sheets? I get it to where I need to flash fill but do not see that option, I will keep digging, suggestion welcome.

Thanks