View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Find & Replace Q

you have double apostrophe in yr fomula = May''08

On 3 Cze, 11:43, Sean wrote:
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