Is posible to search for multiples substrings and replacing them by a set of characters in one line of code? May be a combination of Instr and Mid function?
I want to find the "," and ":" in the string "Hi, my name is: John" and replace the "," for "COMA" and ":" for "DOSP". The result would be line this:
"HiCOMA my name isDOSP John"
Can anybody tell me if it is posible?
Juan M. Bellina