Forum Discussion
find & replace multiple different words at once
Hi, Does anyone know how I can find & replace multiple different words at once in Excel example: dog, cat, bird, pig, cow, chicken ***replace with a single word*** fish
= LET(
rgx, {"dog|cat|cow|duck|chicken"},
REGEXREPLACE(text, rgx, "fish")
)
