turn off hyperlink

[John]

People,
I'm using Office 2004 on an eMac running OS 10.2.8. I have a simple
spreadsheet of people's names and addresses. I wanted to also include
their e-mail addresses so I started typing that info into a new column.
However as soon as I typed it in, Excel underlined it and wanted to
treat it as a link to my Mail application. I finally figured out how to
delete the hyperlink for each entry but isn't there a global setting
somewhere that I can uncheck so Excel doesn't automatically set up an
e-mail hyperlink every time I enter text that "looks" like an e-mail
address?

John

 

[JE McGimpsey]

People,
I'm using Office 2004 on an eMac running OS 10.2.8. I have a simple
spreadsheet of people's names and addresses. I wanted to also include
their e-mail addresses so I started typing that info into a new column.
However as soon as I typed it in, Excel underlined it and wanted to
treat it as a link to my Mail application. I finally figured out how to
delete the hyperlink for each entry but isn't there a global setting
somewhere that I can uncheck so Excel doesn't automatically set up an
e-mail hyperlink every time I enter text that "looks" like an e-mail
address?

No global setting, but a workaround:

http://www.mcgimpsey.com/excel/nohyperlinks.html

and for a "permanent" solution:

http://www.mcgimpsey.com/excel/nohyperlinks2.html

 

[litttle.creature.inc]

No global setting, but a workaround:

http://www.mcgimpsey.com/excel/nohyperlinks.html

and for a "permanent" solution:

http://www.mcgimpsey.com/excel/nohyperlinks2.html

Another way how to remove hyperlinks from text:
select the column where you have the email addresses do APPLE+C, then
Edit>paste>special and chech values - this will remove the hyperlinks.

 

[Kurt]

Another way how to remove hyperlinks from text:
select the column where you have the email addresses do APPLE+C, then
Edit>paste>special and chech values - this will remove the hyperlinks.

Only problem with this for me is that paste special is greyed out in all
instances. Office 2004 on Tiger.

 

[Kurt]

Another way how to remove hyperlinks from text:
select the column where you have the email addresses do APPLE+C, then
Edit>paste>special and chech values - this will remove the hyperlinks.

Forgot that you need to do the whole column. did special, then checked
values, still nothing happens. I think you're missing something.

 

[JE McGimpsey]

Another way how to remove hyperlinks from text:
select the column where you have the email addresses do APPLE+C, then
Edit>paste>special and chech values - this will remove the hyperlinks.

Hmmm... this doesn't work for me in XL04. The hyperlinks remain.

 

[Daiya Mitchell]

Hmmm... this doesn't work for me in XL04. The hyperlinks remain.

I'm finding this works well if I paste the email address in another
cell, but not if I try to paste it over itself. (Which is still a handy
trick to learn)

I have Paste Values on the toolbar, but same result if I go through Edit
| Paste Special.

Excel 11.3.3, Tiger 10.4.8

Daiya

 

[John]

People,
I'm using Office 2004 on an eMac running OS 10.2.8. I have a simple
spreadsheet of people's names and addresses. I wanted to also include
their e-mail addresses so I started typing that info into a new column.
However as soon as I typed it in, Excel underlined it and wanted to
treat it as a link to my Mail application. I finally figured out how to
delete the hyperlink for each entry but isn't there a global setting
somewhere that I can uncheck so Excel doesn't automatically set up an
e-mail hyperlink every time I enter text that "looks" like an e-mail
address?

John

People,
My thanks to all of you for responding. This looks like one of those
cases where the application software has been overdesigned. That is, it
has gone too far in anticipating what the user wants to do. Not
everybody wants "fries with their hamburger" but the prevailing approach
is to include the "fries" as part of the package. Too bad.

At any rate, I love VBA but I am an infrequent Excel user so I don't
think I want to go that route just to solve this little irritant. I did
like two of the simpler approaches. Adding an apostrophe at the
beginning is very acceptable. I also tried the Edit/Copy/Paste Special
but as Daiya pointed out, it only works when the data is pasted to a new
column.

Thanks again - problem solved.

John
Project MVP

 

[Daiya Mitchell]

Another option--

type the email address, let it transform as you tab, then immediately
use command-z to Undo the formatting as a hyperlink and leave just the
plain text.

 

[little_creature]

Well, Then Comrades from NDR made a mistake
[from Pelisky movie]

Interesting, because when you have formulas in any column and do Apple+c and
paste special as values into SAME column then the formulas are overwritten
by the values, but obviously this is not true for hyperlinks...

Then you need to include 2 more steps... Insert 1column do do trick with
paste special and in the end delete the original column with hyperlinks.

 

[PhilD]

Interesting, because when you have formulas in any column and do Apple+c and
paste special as values into SAME column then the formulas are overwritten
by the values, but obviously this is not true for hyperlinks...

The hyperlink is held in the cell, rather than the text within it. If
you have a cell with a hyperlink, you can delete the text from it
(ctrl-U --> delete text, not highlight cell and delete), but it
remains an active hyperlink.

I can't think of any reason on earth why anyone would want this, but I
suppose someone must, otherwise it wouldn't!

PhilD

 

[JE McGimpsey]

I can't think of any reason on earth why anyone would want this, but I
suppose someone must, otherwise it wouldn't!

I can think of one right off - if I paste an email address, and it adds
a hyperlink, I can then edit the cell to just have the name, and it will
still work to send an email to the correct address.

Another would be to replace a long URI with a meaningful word or phrase.

Of course, one could always do this via the Hyperlink dialog, but
in-cell editing is easier.