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
|