Excel - Find and Replace Macro?

[bloodline76]

Anyone help out with a macro? I need to be able to find and replace multiple words in an excel document.

Eg: Find: 501800 Replace: Made up text message

There are about 50 different words that need finding and replacing with text messages.

Thanks

 

[bloodline76]

It would take a very long time. It's a lot more complicated than just finding and replacing. Plus it is a daily job and I am not the only one who has to do it, so it would be quicker doing this as a macro.

 

[bloodline76]

Thanks I will try that out