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.
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.