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
Bookmarks