Find & Replace Q

[Sean]

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

 

[Jarek Kujawa]

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

 

[Sean]

I do but its a straight =Link that created it by Excel. Even if I try
to replace May''08 with May''09 it still can't find it

 

[Jarek Kujawa]

try to replace *'' with *'

 

[Sean]

Same message, can't find match

 

[Jarek Kujawa]

sorry for previous post

try replacing 08.xls] with 09.xls]

works fine on my PC

 

[Sean]

Bingo, that worked, Thanks

I've had it before when there is a space in the sheet name, I can't
figure out how to Find & Replace. I end up re-naming the sheet without
any spaces and it works fine. There must be some structure I'm missing

 

[Jarek Kujawa]

never use spaces in (any) names, that's my habit

use "_" instead