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!!
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.
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" ;()
If you watch on youtube you should see the Thanks button where you can 'buy' us a coffee. Hopefully the trick saved you enough time to have your own coffee.
Great. If you are working with email addresses in Excel then perhaps ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kzfbxuDjwDg.html will interest you where we show how to match parts of names to email addresses. Don't forget to subscribe and click the bell, as we are releasing a new Excel tip or trick every weekday!
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!
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)?
Pleasure. If you are working with emails, perhaps you need to also look at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kzfbxuDjwDg.html which shows how to match names to email addresses?