VBA FIND/REPLACE

Hello,

 

I need to replace certain words (which are written in ” “) from SPanish to English

As I have over 500 words, I want to automize the manual replaceing process (serch for first word, replace by corresponding word in English) 

 

I have the following table:

 

Nuevo Comentario      New Comment

Desgargar                  Download

….                            …

 

And the following text in which I would like to replace “Nuevo Comentario” by “New Comment”

and “Desgargar” with “Download” 

$idm_boton_nuevo_comentario = “Nuevo comentario”;

$idm_descargar = “Descargar”;


    

Which formular/macro could I use to apply this to a large list of replacements (is to say I can´t type in every word that should be replaced rather I would like to search for the word in ” ” and replace it by the corresponding translation in English).

 

Thank you for your help! 

    

 

 

By: Hannah

25 thoughts on “VBA FIND/REPLACE

  1. dig this

    Thank you for sharing excellent informations. Your website is so cool. I am impressed by the details that you¦ve on this website. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for more articles. You, my friend, ROCK! I found just the info I already searched everywhere and just couldn’t come across. What a great web-site.

  2. read here

    Hi! This is kind of off topic but I need some guidance from an established blog. Is it very hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about setting up my own but I’m not sure where to start. Do you have any ideas or suggestions? Thanks

  3. steroide kaufen

    I’m impressed, I need to say. Really rarely do I encounter a weblog that’s each educative and entertaining, and let me tell you, you have hit the nail on the head. Your thought is outstanding; the issue is one thing that not enough individuals are talking intelligently about. I’m very happy that I stumbled across this in my search for something relating to this.

  4. ephedrin kaufen

    naturally like your web site however you have to test the spelling on several of your posts. A number of them are rife with spelling problems and I find it very bothersome to inform the reality nevertheless I will definitely come again again.

  5. Acquista Insulina Per Diabetici In Linea

    It is appropriate time to make some plans for the future and it is time to be happy. I have read this post and if I could I want to suggest you some interesting things or suggestions. Perhaps you can write next articles referring to this article. I wish to read more things about it!

  6. acheter steroides France

    Hi, I think your site might be having browser compatibility issues. When I look at your website in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, fantastic blog!

  7. Ephedrine kaufen

    I have been browsing on-line more than 3 hours these days, but I never discovered any interesting article like yours. It?¦s pretty worth enough for me. In my view, if all webmasters and bloggers made excellent content as you probably did, the net can be a lot more helpful than ever before.

  8. Brookwood Camps

    I blog often and I really thank you for your
    content. This article has truly peaked my interest.

    I am going to bookmark your site and keep checking for new details about once a week.
    I subscribed to your Feed as well.

  9. CBD Skin Care

    I beloved as much as you will obtain carried out proper here. The caricature is attractive, your authored subject matter stylish. nonetheless, you command get bought an impatience over that you would like be turning in the following. ill no doubt come more until now once more as precisely the same nearly very ceaselessly inside case you defend this increase.

  10. Buy CBD Oil

    Hey there, You have done an incredible job. I will certainly digg it and personally suggest to my friends. I am sure they’ll be benefited from this site.

  11. learn more

    I think this is among the most important info for me. And i’m satisfied studying your article. But wanna commentary on few general things, The web site taste is perfect, the articles is actually great : D. Excellent process, cheers

  12. Marvin Codispot

    I loved as much as you will receive carried out right here. The sketch is attractive, your authored material stylish. nonetheless, you command get bought an shakiness over that you wish be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly very often inside case you shield this hike.

Comments are closed.