On 11/06/2007 11:41 PM, Michele wrote:
>>
> Hello Allen,
>
> As I see it you should *not* do what NoOP is suggesting because this will
> simply transform the hyperlink into normal text which is not what you want.
> I am afraid you will need to write a macro to do what you want. Basically
> you ha
Michele wrote:
On 11/7/07, NoOp <[EMAIL PROTECTED]> wrote:
On 11/06/2007 06:03 PM, Allen wrote:
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 P
On 11/7/07, NoOp <[EMAIL PROTECTED]> wrote:
>
> On 11/06/2007 06:03 PM, Allen wrote:
> > 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:[EMAI
On 11/06/2007 06:03 PM, Allen wrote:
> 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 t