replace certain characters with other characters in a cell

[Shan]

For example if cell A1=http://google.com/help=me

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

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

 

[Chip Pearson]

Try

With Range("A1")
.Value = Replace(Replace(.Value, "/", "$"), "=", "$")
End With


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com