+ Reply to Thread
Results 1 to 4 of 4

Email colomn question

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2000
    Posts
    7

    Email colomn question

    Our club has a spreadsheet using ms excel .xls and has a column dedicated to email addresses.
    Typing in this column changes font, size and color. When touching an item in this column a mailto
    page pops up from outlook, that I don't even use.
    This column has been formatted to do this and I would like to change it to a regular column, same font, size and color as the
    rest of the spreadsheet. I have tried doing this and have been unsuccessful and has just reverted back.
    Can someone please point me to the procedure to unlock this column.
    Many thanks.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Email colomn question

    https://support.office.com/en-us/art...ad=US&fromAR=1

  3. #3
    Registered User
    Join Date
    12-11-2012
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2000
    Posts
    7

    Re: Email colomn question

    Thanks Tim, Everything in that and other sites I've checked end up loosing the text.
    I'm using Excel 2007 and have read that there is no procedure that you wont loose the text.
    I have one column that contains emails and need to remove hyperlinks.
    Would like to hear if anyone that has done this.
    Many thanks...

  4. #4
    Registered User
    Join Date
    12-11-2012
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2000
    Posts
    7

    Re: Email colomn question

    Excel 2007 doesn't allow, to my knowledge the ability of deleting a hypertext structure in a column without deleting your text.

    [solved]
    Copy the column and Paste it in Word Pad (will not accept the hypertext formula just the text).
    Delete the Hypertexted column in Excel and Insert a blank column back .
    Copy the text in Word Pad and Paste in the new column in Excel and presto.
    Worked perfectly. Hope this helps someone.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Question about email Pinging using VBA
    By calvinloo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2015, 10:05 PM
  2. Replies: 4
    Last Post: 10-29-2012, 10:26 AM
  3. how to apply Formula at all colomn without the first colomn
    By ramiyousef in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-19-2012, 03:31 AM
  4. Email Question
    By Maull in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2010, 10:55 PM
  5. Email question for Ron de Bruin?
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2006, 05:25 PM
  6. Email workbook question
    By pete3589 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2005, 10:32 AM
  7. [SOLVED] Email question Please.
    By Steved in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2005, 12:05 PM

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