find and replace

[TCampb2]

I am trying to do a find and replace on formulas that are linked to a
specific tab and then replace the name of one tab with another, and it can't
seem to recognize the name. The tabs have date name with a yyyymm format so
I need to change '200110 to 200112' to '200201 to 200203' I can't seem to
figure out why the simple replace doesn't work. Any thoughts or
suggestions???

Thanks,
Tiffany

[CLR]

Maybe in one place your "numbers" are "numbers" and in the other they are
actually "text" that just looks like numbers..........

Vaya con Dios,
Chuck, CABGx3


"TCampb2" <TCampb2@discussions.microsoft.com> wrote in message
news:C96E7E05-D03E-428E-8BEB-BA72998E640E@microsoft.com...
> I am trying to do a find and replace on formulas that are linked to a
> specific tab and then replace the name of one tab with another, and it
can't
> seem to recognize the name. The tabs have date name with a yyyymm format
so
> I need to change '200110 to 200112' to '200201 to 200203' I can't seem
to
> figure out why the simple replace doesn't work. Any thoughts or
> suggestions???
>
> Thanks,
> Tiffany

[Gord Dibben]

Tiffany

What happens when you try?

Nothing? Error message? Excel can't find anything to replace?

May be possible you have an extra space or two in the sheet tab names.

Using your example I had no problem with the replace or the returning new
values based on the changed names.


Gord Dibben Excel MVP


On Mon, 18 Apr 2005 15:28:04 -0700, "TCampb2"
<TCampb2@discussions.microsoft.com> wrote:

>I am trying to do a find and replace on formulas that are linked to a
>specific tab and then replace the name of one tab with another, and it can't
>seem to recognize the name. The tabs have date name with a yyyymm format so
>I need to change '200110 to 200112' to '200201 to 200203' I can't seem to
>figure out why the simple replace doesn't work. Any thoughts or
>suggestions???
>
>Thanks,
>Tiffany