Hi gang,

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?

Thanks,

Allen Schaaf - CISSP, C|EH, C|HFI, CEI
Business Process Analyst - Information Security Analyst
Training & Instructional Designer - Sr. Documentation Developer
Certified Network Security Analyst and Intrusion Forensics Investigator - Certified EC-Council Instructor

Security is lot like democracy - everyone's for it but
few understand that you have to work at it constantly.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to