View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default substitute chatracters within a cell

Range("A1") = Replace(Replace(Range("A1").Text,"\","$"),"=","$")

--
Regards,
Tom Ogilvy


"Shan" wrote:

For example:

If cell A1=http://google.com/help=me

I want to replace all '/' and '=' with $

so A1=http:$$google.com$help$me