Tim Chambers
New Member
- Joined
- Mar 3, 2005
- Messages
- 3
I have a rather extensive data base that I'd like to get the email addresses out of the persons name and actually display
i.e. Cell A1 has 'John Doe' as the data but if you go over it you get 'mailto:JohnDoe@TheInternet.com'
I want to extract his email address from A1 and place it in cell B1
When recording the macro I right clicked/hyperlink/copy hyperlink/paste
It worked great...however when I run the macro B1 just says John Doe with the the hyperlink if you go over the cell; just as the original cell A1
Thanks
i.e. Cell A1 has 'John Doe' as the data but if you go over it you get 'mailto:JohnDoe@TheInternet.com'
I want to extract his email address from A1 and place it in cell B1
When recording the macro I right clicked/hyperlink/copy hyperlink/paste
It worked great...however when I run the macro B1 just says John Doe with the the hyperlink if you go over the cell; just as the original cell A1
Thanks