Removing Links From Cells

[SamuelT]

Hi all,

Can anyone tell me how to remove links from cells? I have a workboo
that has a number of cells copied from another workbook. I want to kee
the formula that the cells have, but remove the link from the paren
spreadsheet.

Any ideas?

TIA,

Samuel

 

[Martijn]

find and replace ?

 

[Dave Peterson]

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

And depending on what version of excel you're running, you may be able to use:

Edit|Links
select the link you don't want
and click the Break link button