Converting a Hyperlink to Show Actual Email Address, Not Be a Link

Hi this is my first post. I wasn't sure if this would be a macro or not, so I posted it here... hope this is the right location.

I am using Office XP Professional and Excel 2000. I have a document which has hyperlinks. Is there a macro or a way to make it show the actual email address [email protected] instead of John Doe, President and having to click on it as link? Also, would there be a way, to keep it showing, John Doe, President (without linking) so I keep the person's information as well as get the email address? I will have hundreds if not thousands of these in my document, so I don't want to have to manually do it if at all possible.

Thank you very much for your time and help.

Thank you very much. I got that to work. A follow up question... if I have an entire column I need to to convert can I do it all at once? Would I just type in (A1:A100) or whatever?

I can't seem to get this to work though I'm working with a web address and not an email address. I'm on Office 2003 and tried both copy-pasting and typing in the function manually. I think I followed the directions exactly but see a compile error when entering in 'GetAddress(A1).' Any ideas?

Got it working just fine on Microsoft 2007.