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 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