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
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.
Hey mate send it through i can use 365 Web for free by the looks of it.
https://www.microsoft.com/en-au/microsoft-365/free-office-online-for-the-web
https://www.microsoft.com/en-au/microsoft-365/free-office-online-for-the-web
- I can also use google sheets if this helps
It seems I have something working decently with Power Query:
- Could you share with i.e. OneDrive, Google drive (or the like) a workbook with a representative dataset?
- More importantly what does a word mean with regard to what you expect? For example:
- We have value "A cow-boy and a cow at farm" & you want to replace cow with fish. Should cow-boy be replaced as fish-boy?
- Same question as above with value "A cow_boy and a cow at farm"
...etc
