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
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)
=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 formular regexreplace only available for Office 365 Beta channel.
I guess your Excel should not support it.
Have you tried the webservice?- I'm using Microsoft Office Professional Plus 2021
Could you explain more on the webservice and how that works?