If you click and hold OE won't open.

So if you had emails adds in A1:A10 click and hold A1 then drag down to
select all.

Then copy and paste.

If you don't want these as hyperlinks, run this macro on the selected range.

Sub Delete_Hyperlinks()
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
Cell.Hyperlinks.Delete
Next Cell
End Sub

To prevent Excel from treating these as hyperlinks when you enter them in
the future go to ToolsAutocorrect OptionsAutoFormat as you type.

Clear the option at Internet and network paths with hyperlinks.


Gord Dibben MS Excel MVP

On Thu, 25 Jun 2009 11:51:01 -0700, Exceluser2400
wrote:

When I click on a cell that contains an email address Excel automatically
opens Outlook Express and tries to send an email to that address. Once I have
clicked on the cell the formatting changes to blue text with underlining and
becomes a hyperlink. The next time I click that cell it opens Outlook
Express, and I have to wait for that program to finish opening and then close
it. But usually I just need to copy the address to paste it into another
application. How can I remove the hyperlink formatting, and how can I
prevent clicking on the cell from opening Outlook Express? I have found
nothing about this in the Help feature.