Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting email addresses from hyperlinks.
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 | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
How do I export email addresses from Excel to Outlook? | Excel Discussion (Misc queries) | |||
make XL stop interpreting email addresses as highlighted links? | Excel Discussion (Misc queries) | |||
Finding email addresses in cells | Excel Worksheet Functions | |||
Format email addresses | Excel Discussion (Misc queries) |