Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a database in which there are email IDs that are marked in different colors based on the previous responses. I want to remove only hyperlinks, as whenever I am trying to work it is taking me to the respective links.

share|improve this question
Edit your question: what is "based on the previous responses"? Include a screenshot of your spreadsheet. It looks as if you just want to remove the automatic hyperlinks in Excel. If that is the case, remove all other non-essential texts from your question. And remove your email. – Jan Doggen Aug 22 '13 at 7:13

What it sounds like you're asking is that you have cells with email addresses that are formatted both with hyperlinks and with colors indicating "previous responses" and that you want to strip out the hyperlinks without losing other formats.

Excel 2010 added a new feature to the Clear button. Select the email IDs, click on the Clear drop down, and then click on Clear Hyperlinks.

If you are using an earlier version of Excel, try the trick outlined at this link: Copy the data to a new column using Paste Values. Next, delete the original data you copied (deleting the data and the hyperlinks, but not the formatting. Copy the data again and use Paste Values to return the data to its original location.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .