Macro for removing 2 letters words

If this task isn't something you'll need to do regularly, I'm thinking you could just use find and replace. Not as interesting as a macro, but it would work fine and be relatively fast since there aren't too too many two letter words likely to exist. Select all the data and use Find and replace on anything that is [Space] letter letter [Space] with a single [Space], and repeat for each word.

so find " in " and replace with " "

The macro would be interesting and I'd like to see one, but if this is an immediate need, a manual find/replace that would work for you as well and would only take a few minutes. Unless there are a lot of combinations that aren't words like xo and qm or something, in which case...macro

Try this:

Please Login or Register  to view this content.

Hi haoxu

This code works to remove the 2 letter words, however, not sure where to add the code for the exceptions. Perhaps someone else can assisst in editing as required.

Please Login or Register  to view this content.

This uses Regular Expressions to filter all two-letter words. The RegEx pattern could be adjusted to exclude a list of two-letter words, but I don't know how to add the word exclusions. Perhaps someone could suggest a pattern.

Please Login or Register  to view this content.

@ jolivanes

Well look at that....Fantastic...Thanks for the lesson

Hey there Indi_Ra

It is not actually about who wrote the code...The forum is a platform where one learns from....As long as the code works....That is important.

Originally Posted by sintek

Hey there Indi_Ra

It is not actually about who wrote the code...The forum is a platform where one learns from....As long as the code works....That is important.

Probably we have different concepts....
If we took VBA code from someone, it is normal and common sense, to say who wrote it and do not take credit...
As I said it is primarily a matter of common sense...

If someone steals your heat from your head, could have an excuse, raining outside....

@sintek - we all learn from each other and we all borrow bits of code and integrate it into our code and modify it etc - then it becomes our code - and that is fine.

If we take someone else's code and do not change it (or change it very little) then it is still their code - they don't "own" it, but it is still their work.
If you then post it elsewhere, it is "etiquette" to mention the source (if you can remember) and it is very nice for the code writer to be given credit.
It costs you nothing and to the rest of us it makes you a "better person" for being honest about who wrote the code.
The originator gets the credit, the person with the problem gets a solution, you get an acknowledgement for helping that person etc - WIN, WIN , WIN

@ kev

I understand..Thank you

Originally Posted by Indi_Ra

Probably we have different concepts....
If we took VBA code from someone, it is normal and common sense, to say who wrote it and do not take credit...
As I said it is primarily a matter of common sense...

If someone steals your heat from your head, could have an excuse, raining outside....

Agreed, thanks

I agree that anything posted on a public forum becomes - well public domain.

Having said that though, common courtesy would be to post acknowledgement on where the code/formula/whatever came from

Originally Posted by kev_

@sintek - we all learn from each other and we all borrow bits of code and integrate it into our code and modify it etc - then it becomes our code - and that is fine.

If we take someone else's code and do not change it (or change it very little) then it is still their code - they don't "own" it, but it is still their work.
If you then post it elsewhere, it is "etiquette" to mention the source (if you can remember) and it is very nice for the code writer to be given credit.
It costs you nothing and to the rest of us it makes you a "better person" for being honest about who wrote the code.
The originator gets the credit, the person with the problem gets a solution, you get an acknowledgement for helping that person etc - WIN, WIN , WIN

Well said. We do not have an explicit rule requiring it here, but professional courtesy requires that you credit the source of code if you did not write it yourself.

Originally Posted by sintek

Hey there Indi_Ra

It is not actually about who wrote the code...The forum is a platform where one learns from....As long as the code works....That is important.

Hey guys. I have only been able to get to this point in my "Beginner" level of VBA by searching the web and making use of this Amazing Forum.
I have always taken code found on the web and adjusted to suite my requirements, sometimes just a small tweak and sometimes large tweaking.
I have never assumed to be the code writer and have always thanked the Contributor if assistance came from this site. I learned something new today and promise in future will always give credit to the original author...

Nice one @sintek