View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default Find & Replace Q

I am having a difficulty in Find & Replacing some text. The following
is a formula within a cell:-

='F:\Sean\My Documents\Reports\Add Reports\Large Customer Analysis\
[Large Cust June - May''08.xls]Report'!$W36

I am looking to replace all instances of May'08 with May'09 (this will
then reference to another file). But it returns "No matches found" -
am I doing this the correct way?


Thanks

Sean