Removing email address links

[starguy]

I have forgotton the option to make the email address as underlined
link. where it is so that I could uncheck it?

 

[seanrigby]

If you want to remove the hyperlink, try Right-clicking the address yo
want to deactivate, point to Hyperlink on the shortcut menu, and the
click Remove Hyperlink

 

[Dave Peterson]

Tools|autocorrect options|autoformat as you type tab
uncheck the "Replace as you type" box

 

[starguy]

no effect Dave, seanrigby's suggestion works

Tools|autocorrect options|autoformat as you type tab
uncheck the "Replace as you type" box



http://www.excelforum.com/showthread.php?threadid=556472

 

[Dave Peterson]

That setting won't affect any existing links. But it will stop any of your new
entries from converting to hyperlinks.

 

[starguy]

I have many email addresses which I have already entered in a column.
want them to be as text not hyperlinks.

some cells in that column are empty and some have email addresses
want those emails (which are now hyperlinks) to be as text and those a
well which I enter later.
how could this be done

 

[Dave Peterson]

You can select the range of cells that contain hyperlinks.

Then hit alt-f11 to get to the VBE
then hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

You can select as many or as few cells as you want.

 

[starguy]

thanks it solved my problem.