Sorro911Copper ContributorAug 27, 2024find & 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 Show More
pvela23Copper ContributorSep 03, 2024Sorro911 This is little vague, but you can try this.=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1, "dog", "fish"), "cat", "fish"), "bird", "fish"), "pig", "fish"), "cow", "fish"), "chicken", "fish")
