Are doing it in VBA? In xl2000 or later

s = "$A$6:$A$15"

s1 = Replace(s,"A","T")

--
Regards,
Tom Ogilvy


"alvin Kuiper" wrote in message
...
Hi

If i have
$A$6:$A$15 in a string

And i whant to change A to T
how can i easy do that?

Alvin