Dear Ashish You can do it without a macro by using the Paste Special features of Excel. Follow these steps:
1. In a blank cell, enter the number 1. 2. Select the cell and press *Ctrl+C*. The cell content (1) is now copied to the Clipboard. 3. Hold down the *Ctrl* key as you click each hyperlink you want to remove. 4. Display the Paste Special dialog box. (In versions of Excel before Excel 2007 choose Edit | Paste Special. In Excel 2007 display the Home tab of the ribbon, click the down-arrow under the Paste tool at the left of the ribbon, and then choose Paste Special.) 5. Select the Multiply radio button. 6. Click OK. All the hyperlinks are removed, but the text of the hyperlinks remain. 7. Delete the cell you created in step 1. Yahya On Sat, Jun 13, 2009 at 11:38 AM, Ashish Pradhan <ashlyprad...@gmail.com>wrote: > > Dear Yahya > > Thanks for your help and apologize for not posting all details in my > query earlier. The excel version I am using is Excel 2000. > > > Thanks again. > > > Ashish > > On 6/13/09, Yahya <yahya...@gmail.com> wrote: > > > > > > Dear Ashish > > > > > > Which version of Excel you are using? > > > > > > > > Yahya > > > > On Fri, Jun 12, 2009 at 12:44 PM, Ashish Pradhan <ashlyprad...@gmail.com > > > > wrote: > > > > > > > > Hi > > > > > > I have downloaded some tables in excel using Copy/Paste Function (Not > > > the "Get External Data" feature). Unfortunately, there are a lot of > > > links in the excel cells. > > > > > > Is there any way to remove all hyperlinks from an excel file > > > (workbook) instead of doing it manually one cell at a time? > > > > > > Appreciate any help in this and thanks a lot in advance. > > > > > > > > > Thanks > > > > > > -- > > > "I disapprove of what you say, but I will defend to the death your > > > right to say it" > > > > > > Ashish Pradhan > > > > > > > > > > > > > > > > > -- > > > > > > > > Regards > > > > Yahya > > > > > > > > > > -- > "I disapprove of what you say, but I will defend to the death your > right to say it" > > Ashish Pradhan > > > > -- Regards Yahya --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
