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

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

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

try to replace *'' with *'

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

Same message, can't find match

sorry for previous post

try replacing 08.xls] with 09.xls]

works fine on my PC


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

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

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

use "_" instead


On 3 Cze, 12:39, Sean wrote:
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