Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change color within string? | Excel Discussion (Misc queries) | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
Change part of string to lower | Excel Worksheet Functions | |||
How to change text string? | Excel Discussion (Misc queries) | |||
Change date format in string? | Excel Programming |