My suggestions aren't as elegant as Ana's, but you could copy that 
column from your spreadsheet into NotePad. That would preserve the text 
but remove the hyperlink. Another thing you could do when copying the 
links into your spread sheet is use the paste special options and select 
the text only option.


On 05/14/2018 06:52 PM, Ana G wrote:
> Sherry,
>
>
> To convert an email address to plain text in Excel, tab to the email 
> address, press the applications key, and press enter on Remove 
> Hyperlink. When you're done, the email is still there, but it's not a 
> link.
>
>
> I've only done this with one cell at a time. I'm assuming that 
> selecting the entire row or column works, but I don't know this for a 
> fact.
>
>
> Ciao
>
>
> On 5/14/2018 6:38 AM, Sherry Wells wrote:
>> Hello,
>>
>> I created a spreadsheet that contains a bunch of email addresses.  
>> Since I
>> pasted these in from an email, all the email addresses are links.  I 
>> created
>> this sheet for someone who wants to use it to cut & paste these 
>> addresses
>> into a group.  Since they are links, if he clicks on the cell to copy 
>> it, he
>> is taken to a blank email addressed to that person.  I thought this 
>> would be
>> an easy fix; that I could select the column then change the style to 
>> text.
>> Doing this still leaves the addresses as links though.  Any ideas as 
>> to how
>> I can get these changed to text?
>>
>> Thanks,
>> Sherry Wells
>>
>>
>> ---
>> This email has been checked for viruses by AVG.
>> http://www.avg.com
>>
>>
>>      VICUG-L is the Visually Impaired Computer User Group List.
>> Archived on the World Wide Web at
>>      http://listserv.icors.org/archives/vicug-l.html
>>      Signoff: [log in to unmask]
>>      Subscribe: [log in to unmask]
>>
>
>
>    VICUG-L is the Visually Impaired Computer User Group List.
> Archived on the World Wide Web at
>    http://listserv.icors.org/archives/vicug-l.html
>    Signoff: [log in to unmask]
>    Subscribe: [log in to unmask]

-- 
Christopher (CJ)
Chaltain at Gmail


    VICUG-L is the Visually Impaired Computer User Group List.
Archived on the World Wide Web at
    http://listserv.icors.org/archives/vicug-l.html
    Signoff: [log in to unmask]
    Subscribe: [log in to unmask]