LinkBack URL
About LinkBacks
(SOLVED) -- Excel 2007 -- I'm trying to extract an email address in a hyperlink in one cell and paste it in another cell for range of columns (c1:d50) ... what's the best way to do this?
How do extract an email addr from hyperlink?
(SOLVED) -- Excel 2007 -- I'm trying to extract an email address in a hyperlink in one cell and paste it in another cell for range of columns (c1:d50) ... what's the best way to do this?
Last edited by DBCinCC; 12-07-2010 at 08:26 PM.
What does the hyperlink look like?
See the attached excel sheet which is attached.Originally Posted by mojo249
Hello DBCinCC,
Here is UDT to return the email address from the cell's hyperlink.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks