Donate SIGN UP

Convert plain text email addys in Excel 2010

Avatar Image
bazwillrun | 09:54 Thu 26th Apr 2012 | Technology
2 Answers
For the life of me I cant remember how I did this.
Excel 2010, I have a list of hundreds of plain text email addresses, I cant remember how I converted them to active addresses so that when individually clicked on they open up Outlook 2010.

I can change them one by one by just adding a space at the end of each text address or by making sure autocorrect is on for typing them in one by one, or using the Hyperlink function.

But I want to select the whole column and convert them in one go, I seem to recall this was very easy when I last did it but just cant remember how I did it.

so far my google search has come up with nothing
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by bazwillrun. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Only way is going to be either a macro or a VB script.

I've just checked and this macro works and does what you want.

http://www.mcgimpsey....onverttomaillink.html
Question Author
Thanks.
I've written all sorts of VB scripts for this particular sheet and there isnt one for converting a whole column of email addys, I'm sure I did it with a couple of clicks in the past.

I can use the linked script (need to take out some of the code thats not needed) until i figure out how I did it

1 to 2 of 2rss feed

Do you know the answer?

Convert plain text email addys in Excel 2010

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.