'Multiple REGEXREPLACE in google Sheets
i want to replace 3 caracters in one string
=ARRAYFORMULA({REGEXREPLACE(A5,"c","a"); REGEXREPLACE(A5,"d","x");REGEXREPLACE(A5,"v","y")})
is possible? I want to add it to a query on future too :D ty alot
Solution 1:[1]
should be like:
=REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(A5,"c","a"), "d","x"), "v","y")))
for array:
=ARRAYFORMULA(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(A5:A,"c","a"), "d","x"), "v","y"))))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |