Hao Xu
03-24-2017, 07:57 AM
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.
For example
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 ("is" is not removed because i need this word, as well as a list that i have of 2 letters word)
Thank you in advance guys!
Waiting for your replies.
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.
For example
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 ("is" is not removed because i need this word, as well as a list that i have of 2 letters word)
Thank you in advance guys!
Waiting for your replies.