| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract email address in hyperlink
I copied several hundred email address hyperlinks from an html page into a
spreadsheet. They all showed text as "Click her to email" on the html page. They copied correctly as hyperlink "mailto" links, but the text in the excel field is still "Click her to email". The email links span A1 - A500. I am trying to find a way to show the email address only in B1 - B500. How do i do this? Brossyg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set up a hyperlink in excel to email the doc as attachment | Excel Discussion (Misc queries) | |||
| Don't use your email address in your posts | Excel Discussion (Misc queries) | |||
| Extract email addresses | Excel Worksheet Functions | |||
| Excel Email Hyperlink Bug | Excel Discussion (Misc queries) | |||
| copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
Threaded Mode
