Change value in a string
 

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

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

Change value in a string
 

Hi Alvin,

Assuming your string is located in A1 :
=SUBSTITUTE(A1,"A","T")
will do the job ...

HTH
Cheers
Carim

Change value in a string
 

Use Edit Replace and replace A with T


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=511517

Change value in a string
 

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

Change value in a string
 

Thanks all for your help

Alvin

"Tom Ogilvy" wrote:

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