ExcelBanter - substitute chatracters within a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - substitute chatracters within a cell (https://www.excelbanter.com/excel-programming/364257-substitute-chatracters-within-cell.html)

Shan[_2_]

substitute chatracters within a cell

For example:

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

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

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

Tom Ogilvy

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

All times are GMT +1. The time now is 03:10 AM.