At 18:03 06/11/2007 -0800, Allen Schaaf wrote:
I inherited an .ods spreadsheet that has hyperlinks to an e-mail
address. About 10,000 of them.
The text says "Email Me" but when you look at the hyperlink it says
"mailto:[EMAIL PROTECTED]".
I want to create a column next to it that has just the email address
without having to collect them one by one so that I can send out
group emails to a few people at a time when a subject comes up that
would interest those people.
So how do I de-link them in bulk, not 10,000 one at a time?
See the function ExtractHyperLink at:
http://www.oooforum.org/forum/viewtopic.phtml?p=80625#80625
or the function CELL_URL at:
http://www.oooforum.org/forum/viewtopic.phtml?t=32909 .
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]