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
This would work best if I can learn how to format it correctly. Also is there a way to make his not case sensitive? e.g. DoG|caT|BIRd|coW|CHICKEn > fish
I really appreciate the help! Thanks in advance.
The syntax of the REGEXEXTRACT function is:
REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity])
case_sensitivity
Determines whether the match is case-sensitive. By default, the match is case-sensitive. Enter one of the following:
0: Case sensitive
1: Case insensitive
=WEBSERVICE("https://e.anyoupin.cn/eh3/?regreplace~/dog|cat|bird|pig|cow|chicken/i_@//~fish_@~" & A2)
- Thank you very much for your time and help but non of this has helped.