Treat mail adress as text only

  • Thread starter Thread starter Lars
  • Start date Start date
L

Lars

Hi group,

How can I make Excel (97), let me have e-mail adresses in a
worksheet without them being treated as a mailto-link?

I have a bunch of adresses including some e-mail adresses that
I need to mark and copy one by one without having my mail
client popping up all the time.

As for me Excel *never* needs to trigger any mail proggies.

I have managed to beat Word into submission in this respect,
but it was not easy to find where and how.

My question here is *only* about how to manipulate Excel to my
wishes. Nothing else.


Lars, Stockholm
 
Hi Lars

If you type in a E-mail address you can press Ctrl-Z after you
press enter to make it text

To make text from all your hyperlinks use a macro like this

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run
 
Lars

The way I usually handle the problem is to copy an unused cell, then
Paste/Special/Add onto the cell/column of cells.

Andy.
 
Thanks Ron,

Neat, Ron.

I love this news group!
Whenever I join in again for a while I am impressed with the
slick and straight solutions offered.
Not to mentioned how I am again and again impressed with Excel
itself.

Hi Lars

If you type in a E-mail address you can press Ctrl-Z after you
press enter to make it text

To make text from all your hyperlinks use a macro like this

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run
Click to expand...


Lars, Stockholm
 
Back
Top