Thread: Change value in a string
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Carim[_3_] Carim[_3_] is offline
external usenet poster
  
Posts: 137
Default 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

Reply With QuoteReply With Quote