Change value in a string
On Sun, 12 Feb 2006 12:00:28 -0800, alvin Kuiper
wrote:
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
Perhaps something like:
=SUBSTITUTE("This is a string: $A$6:$A$15","$A$","$T$")
--This is a string: $T$6:$T$15
--ron
|