View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Carter Sean Carter is offline
external usenet poster
 
Posts: 2
Default Find/Replace within links in cells

Hi,

I've got a couple hundred links to folders in an excel spreadsheet. The
folders are all moving to another drive. Is there a way I can do a
Find&Replace but within the hyperlinks?

For example, on every link I would want to change
"\\fs_users\Everyone\USER\Paper Archive\" to "C:\Documents and
Settings\USER\Desktop\Paper Archive\"

Is this possible in Excel 2000? If not, maybe in a newer version?

Thanks,
Sean