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]