View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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