I need some help with links in my damn worksheets. I do not want any,
ever, that I can imagine. I know how to make hotlinks into flat text,
but I wonder is there was a way to make a link into flat text.

I have promised my computer club to share favorite places to give them a
leg up in research and interest in their computers.

I have copied favorite places into an .html document and opened it in
Excel. I now have the [name of the link] as a hyperlink, but can't show
the URL to others in a spreadsheet.

Also referring to the first comment, is there any way for links to not
be introduced into my work, and further, to avoid having email addresses
formatted differently from the rest of the worksheet (as links).

Any advice will be gratefully appreciated.
--

Regards,

P D Sterling
New York, Texas & Texas, New York

Hi,

what do you mean by "hotlinks into flat text" verses link into flat text?

At present how do you convert hotlinks into flat text?


--
Thanks,
Shane Devenshire


"P D Sterling" wrote:

I need some help with links in my damn worksheets. I do not want any,
ever, that I can imagine. I know how to make hotlinks into flat text,
but I wonder is there was a way to make a link into flat text.

I have promised my computer club to share favorite places to give them a
leg up in research and interest in their computers.

I have copied favorite places into an .html document and opened it in
Excel. I now have the [name of the link] as a hyperlink, but can't show
the URL to others in a spreadsheet.

Also referring to the first comment, is there any way for links to not
be introduced into my work, and further, to avoid having email addresses
formatted differently from the rest of the worksheet (as links).

Any advice will be gratefully appreciated.
--

Regards,

P D Sterling
New York, Texas & Texas, New York

my comment was meant to indicate largely turning email addresses from
links into [not]links, because when I am mousing around, it annoys me no
end to go flying into a new email message to said individual. I keep a
certain number of rather small databases in excel, and don't know if
this is a problem in access.

I convert hotlinks into flat text by entering a '1' in the lowest right
cell, and copying it special (Edit|Paste Special|Multiply) to the entire
worksheet, save the originating cell. However in this project, I want to
take the link text (yellow popup box with the target URL) and make it
into a plainly readable URL.

Hope this is a bit clearer.

Regards,

P D Sterling
New York, Texas & Texas, New York


ShaneDevenshire wrote:
Hi,

what do you mean by "hotlinks into flat text" verses link into flat text?

At present how do you convert hotlinks into flat text?