Macro for removing 2 characters words

[HaoXu]

Hi guys!:

I need really need your help for this.
I was looking for a macro that could automatically detect and remove 2 letter words (for example: or, if, hg, wa, rt, op...) in a selected range (it will be almost always in column A)

Also, i wanted to put this macro some words that it should not remove (because i work with some products with 2 letter brand such as LG, CH, DG...) I was thinking that i could add a list to this macro.

Thank you in advance guys!

Waiting for your replies.

 

[AkaTrouble]

can i suggest you provide some before and after samples of what is the original text string and what is the after text string also provide us with 3 examples of allowed 2 letter strings so they can be used as example in the code someone may provide

see my signiture for how to add samples

eg

in and out we went to the top of the hill	and out went the top hill
of one to many we see an answer	one many see answer
df is gh is fe on off	is is on off	N.B. is and on allowed

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[HaoXu]

Hi Akatrouble:

Sorry, i should have provided some samples before.
But you got the idea i wanted to transmit, your sample defines exactly what i'm looking for!