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
16 Replies
- I had an elegant recursive solution for you but realized I was using a few functions not available in Excel 2021. The function gap between 2021 and 365 gets larger by the month it seems.
= LET( rgx, {"dog|cat|cow|duck|chicken"}, REGEXREPLACE(text, rgx, "fish") )Hey mate what am i doing wrong?
- https://prod.support.services.microsoft.com/en-us/office/regexreplace-function-9c030bb2-5e47-4efc-bad5-4582d7100897
=regexreplace(A2,"dog|cat|bird|pig|cow|chicken","fish")
or
=WEBSERVICE("https://e.anyoupin.cn/eh3/?regreplace~dog|cat|bird|pig|cow|chicken~fish~" & A2)
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)
- The formular regexreplace only available for Office 365 Beta channel.
I guess your Excel should not support it.
Have you tried the webservice?
