jamesrossidavid
New Member
- Joined
- Mar 23, 2010
- Messages
- 2
Remove "text To Display" For Hyperlinks
hi
I have a list of Hyperlinks in one column which have always a display name like:
i am using excel 2007
Email
Name
Behind each Email or Homepage a Hyperlink is hidden. But for every Email address in my file the "text to display" is Email.
Can you help me to find a macro which deletes all display names and shows me the hyperlink like this:
Peter@xyz.de
www.google.de
Carl.True@hotmail.com
www.msn.de
etc.
Thanks a lot
Best regards
Rossi
hi
I have a list of Hyperlinks in one column which have always a display name like:
i am using excel 2007
Name
Behind each Email or Homepage a Hyperlink is hidden. But for every Email address in my file the "text to display" is Email.
Can you help me to find a macro which deletes all display names and shows me the hyperlink like this:
Peter@xyz.de
www.google.de
Carl.True@hotmail.com
www.msn.de
etc.
Thanks a lot
Best regards
Rossi