VBA help needed to remove all "/" then replace with "-" from cell "B3"and "B5"

Folks,

Please help me to build a macro to remove all SLASH “/” from Sheet (“Page 1 Cover Page”) Cell “B3” and Cell “B5” then replace with DASH “-“

e.g. if Cell “B3” value is “ABC/DEFG/H” then macro to remove “/” then replace with “-“

The Result must be “ABC-DEFG-H”

e.g. if Cell “B5” value is “ABC/DEF” then macro to remove “/” then replace with “-“

The Result must be “ABC-DEF”

Thanks in advance for your expertise

Maybe:

Please Login or Register  to view this content.

Thank you all.

Great code and advise.