Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,171
- Office Version
- 365
- 2019
- Platform
- Windows
I have a range of strings that contain different values in which I need to replace.
Is there an easy way to replace these characters:
"'", "2", "5", "@", "Q", "v", "b", "g", "v", "{" to 0
"%", "/", ">", "?", "N", "W", "]", "i", "u", "|" to 1
If I have
2?@55| then I need the output to be 00551
>116v742W then I need the output to be 11607401
Thanks in advance
Is there an easy way to replace these characters:
"'", "2", "5", "@", "Q", "v", "b", "g", "v", "{" to 0
"%", "/", ">", "?", "N", "W", "]", "i", "u", "|" to 1
If I have
2?@55| then I need the output to be 00551
>116v742W then I need the output to be 11607401
Thanks in advance