Multiple REGEXREPLACE in google Sheets

user_14679024 0
Viewed 126

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

google-sheets substitution arrays replace regex
1 Answers

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"))))
user_56326290
Related