CODEWITHSUNDEEP
arraysregexgoogle-sheetsreplacesubstitution
Collaxd
Collaxd

Reputation: 181

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

Upvotes: 1

Views: 2725

Answers (1)

player0
player0

Reputation: 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"))))

Upvotes: 1

Related Questions