email addresses in spreadsheet

[Katherine Harris]

I use Excel as an orgainizer of names, addresses, emails,
etc. Whenever I click on an email address, it acts like
a hyperlink and automatically dials up AOL and creates a
message to send. I DO NOT want it to do this! How can I
disable the hyperlink function without making the emails
look different. For example, I do not want to
substite "at" for @, even though I know this will disable
the hyperlink. I like to be able to copy and paste an
entire list into the send to field when I am sending out
a club email.

TIA!

Katherine

 

[Peo Sjoblom]

One way, copy an empty cell, select the email addresses (to select without
clicking a link assume they
are in D2100, in the name box above column A header type D2100 and press
enter),
do edit>paste special and select add

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[keepITcool]

this takes care of the future..

goto tools/autocorrect options
2nd tab.. remove checkmark for autocorrect email addresses.

now you need to remove all existing hyperlinks:

to remove existing hyperlinks..
you could save your sheet as a dif file and reload.
(note any excel specific stuff is lost,
and you can save 1 sheet only, not multisheet...

or insert a new sheet,
copy and paste special values to the new sheet...




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Ron de Bruin]

Hi Katherine

I like to add this to keepITcool his answer

goto tools/autocorrect options
2nd tab.. remove checkmark for autocorrect email addresses.

Only in 2002-2003