+ Reply to Thread
Results 1 to 6 of 6

How do I format email addresses as Text only?

  1. #1
    Dstess
    Guest

    How do I format email addresses as Text only?

    I have a large database with names, addresses etc. When I try to make changes
    to the email address, like change the font color or change on letter, Excel
    tries to email the address. If I click in the formula bar to make the
    changes, it automatically changes it back to all blue text and underlined. I
    have tried to format all of the cells as "Text" to show as entered, but it
    doesnt work. PLEASE HELP

  2. #2
    Bob Phillips
    Guest

    Re: How do I format email addresses as Text only?

    Sneak up on it :-)

    Don't click the cell, click an adjacent cell, and then use the arrow keys to
    navigate to the cell. Change it as you wish.

    Alternatively, get to the cell in the same way and remove the hyperlink
    (Insert>Hyperlink Remove Hyperlink)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Dstess" <Dstess@discussions.microsoft.com> wrote in message
    news:9D14A8E5-0639-4052-BAC6-0238C709671A@microsoft.com...
    > I have a large database with names, addresses etc. When I try to make

    changes
    > to the email address, like change the font color or change on letter,

    Excel
    > tries to email the address. If I click in the formula bar to make the
    > changes, it automatically changes it back to all blue text and underlined.

    I
    > have tried to format all of the cells as "Text" to show as entered, but it
    > doesnt work. PLEASE HELP




  3. #3
    Gord Dibben
    Guest

    Re: How do I format email addresses as Text only?

    If you left-click and hold for 2 seconds it won't do its hyperlink jump.

    The cell will remain selected for formatting/editing.


    Gord Dibben Excel MVP

    On Sat, 8 Jan 2005 11:10:29 -0000, "Bob Phillips"
    <bob.phillips@notheretiscali.co.uk> wrote:

    >Sneak up on it :-)
    >
    >Don't click the cell, click an adjacent cell, and then use the arrow keys to
    >navigate to the cell. Change it as you wish.
    >
    >Alternatively, get to the cell in the same way and remove the hyperlink
    >(Insert>Hyperlink Remove Hyperlink)



  4. #4
    Dstess
    Guest

    Re: How do I format email addresses as Text only?

    Thank you both Bob and Gord,

    I did figure out the right click and remove hyperlink; unfortunatly, I could
    not figure out how to do all of the emails at one time, so I spent WAY too
    much time clicking each one and removing the hyperlink.

    Left click and hold could be helpful later for as new volunteers are added
    it is still changing their addresses to the hyperlink, of course I have now
    gotten use to the "right click, remove" steps so that might take just as much
    time.

    There should be a way to deactivate all hyperlinks in the spreedsheet though.

    Sneak up on it... he he he... cute one.

    Thanks again for your help.


    "Gord Dibben" wrote:

    > If you left-click and hold for 2 seconds it won't do its hyperlink jump.
    >
    > The cell will remain selected for formatting/editing.
    >
    >
    > Gord Dibben Excel MVP
    >
    > On Sat, 8 Jan 2005 11:10:29 -0000, "Bob Phillips"
    > <bob.phillips@notheretiscali.co.uk> wrote:
    >
    > >Sneak up on it :-)
    > >
    > >Don't click the cell, click an adjacent cell, and then use the arrow keys to
    > >navigate to the cell. Change it as you wish.
    > >
    > >Alternatively, get to the cell in the same way and remove the hyperlink
    > >(Insert>Hyperlink Remove Hyperlink)

    >
    >


  5. #5
    Bob Phillips
    Guest

    Re: How do I format email addresses as Text only?

    The quickest way that I have found, and an approach you can use in many
    other circumstances , is to use the Repeat Action function key, F4.

    Select cell A1, right-click and remove the hyperlink.
    Then use the down arrow key, and press F4,
    Repeat ad nauseum.

    You still have to select every cell, but only one right-click, and you can
    do it in a co-ordinated manner, right hand down arrow, left F4, it gets
    quite efficient.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Dstess" <Dstess@discussions.microsoft.com> wrote in message
    news:921E90C1-F8C8-4A10-8106-0EFAA68885C3@microsoft.com...
    > Thank you both Bob and Gord,
    >
    > I did figure out the right click and remove hyperlink; unfortunatly, I

    could
    > not figure out how to do all of the emails at one time, so I spent WAY too
    > much time clicking each one and removing the hyperlink.
    >
    > Left click and hold could be helpful later for as new volunteers are added
    > it is still changing their addresses to the hyperlink, of course I have

    now
    > gotten use to the "right click, remove" steps so that might take just as

    much
    > time.
    >
    > There should be a way to deactivate all hyperlinks in the spreedsheet

    though.
    >
    > Sneak up on it... he he he... cute one.
    >
    > Thanks again for your help.
    >
    >
    > "Gord Dibben" wrote:
    >
    > > If you left-click and hold for 2 seconds it won't do its hyperlink jump.
    > >
    > > The cell will remain selected for formatting/editing.
    > >
    > >
    > > Gord Dibben Excel MVP
    > >
    > > On Sat, 8 Jan 2005 11:10:29 -0000, "Bob Phillips"
    > > <bob.phillips@notheretiscali.co.uk> wrote:
    > >
    > > >Sneak up on it :-)
    > > >
    > > >Don't click the cell, click an adjacent cell, and then use the arrow

    keys to
    > > >navigate to the cell. Change it as you wish.
    > > >
    > > >Alternatively, get to the cell in the same way and remove the hyperlink
    > > >(Insert>Hyperlink Remove Hyperlink)

    > >
    > >




  6. #6
    Gord Dibben
    Guest

    Re: How do I format email addresses as Text only?

    To remove all hyperlinks in a selection.

    Sub removeAllLinksFromSelection()
    Selection.Hyperlinks.Delete
    End Sub


    Gord

    On Sun, 9 Jan 2005 00:21:02 -0800, Dstess <Dstess@discussions.microsoft.com>
    wrote:

    >Thank you both Bob and Gord,
    >
    >I did figure out the right click and remove hyperlink; unfortunatly, I could
    >not figure out how to do all of the emails at one time, so I spent WAY too
    >much time clicking each one and removing the hyperlink.
    >
    >Left click and hold could be helpful later for as new volunteers are added
    >it is still changing their addresses to the hyperlink, of course I have now
    >gotten use to the "right click, remove" steps so that might take just as much
    >time.
    >
    >There should be a way to deactivate all hyperlinks in the spreedsheet though.
    >
    >Sneak up on it... he he he... cute one.
    >
    >Thanks again for your help.
    >
    >
    >"Gord Dibben" wrote:
    >
    >> If you left-click and hold for 2 seconds it won't do its hyperlink jump.
    >>
    >> The cell will remain selected for formatting/editing.
    >>
    >>
    >> Gord Dibben Excel MVP
    >>
    >> On Sat, 8 Jan 2005 11:10:29 -0000, "Bob Phillips"
    >> <bob.phillips@notheretiscali.co.uk> wrote:
    >>
    >> >Sneak up on it :-)
    >> >
    >> >Don't click the cell, click an adjacent cell, and then use the arrow keys to
    >> >navigate to the cell. Change it as you wish.
    >> >
    >> >Alternatively, get to the cell in the same way and remove the hyperlink
    >> >(Insert>Hyperlink Remove Hyperlink)

    >>
    >>



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1