• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple replace of different things.

P

Pampos

Guest
Hello. Is it possible to replace multiple word at once. For example, I have that list:

A B
cat dog
love hate
234 456

It' s long list. Is there a way that I can replace every word of column A with the word of column B at once? Not by use the replace option so many times...
 
The words are in many different cells and sheets. I want to replace all "cat" with "dog" and the same time "love" with "hate"...
 
I have to do this for all 50 cases... I just want an easiest way.
 
Hi ,

Writing code is made easy if details of your data layout and some amount of data for testing is available.

Once the code is written and uploaded , you can always learn from that.

As for learning VBA , there are a lot of good sites , one of which is :

https://excelmacromastery.com/

Writing code without an idea of how your data is laid out is a trial and error affair ; some code will be submitted ; it might or might not work ; errors will be pointed out , and they will be corrected , and this process will iterate till the code does what you want it to do.

I do not know whether too many members will have the patience to go through this process.

Narayan
 
You must log in or register to reply here.
Back
Top