How do I install and use this option explicit post?

[HowdeeDoodee]

This question appeared on another board. If allowed, I would like to get an answer from this board. I tried to get the code to work but could not be successful. what do I have to do to make the code work? How do I install the stop words when the stop words number over a thousand?

code:

Option Explicit

Sub RemoveSeparators()
' stanleydgromjr, 07/06/2012
' Removing 'stop words' from a sentence in excel [SOLVED]
Dim s, b
Dim i As Long, ii As Long, lr As Long, h As String
s = Array("this ", "This ", "is ", "Is ", "of ", "Of ", "I ", "i ", "have ", "Have ", "and ", "And ", "from ", "From ", "a ", "A ", "the ", "The ", "it ", "It ", "over ", "Over ", "it's ", "It's ", "has ", "Has ", "that ", "That ", "coming ", "Coming ")
lr = Cells(Rows.Count, 2).End(xlUp).Row
b = Range("B2:C" & lr).Value
For i = LBound(b, 1) To UBound(b, 1)
h = Trim(b(i, 1))
If Right(h, 1) = "." Then h = Left(h, Len(h) - 1)
For ii = LBound(s) To UBound(s)
h = Replace(h, s(ii), "")
Next ii
b(i, 2) = h
Next i
Range("B2:C" & lr).Value = b
End Sub

Sheet:

Sno	Sentence	Resulting sentence
1	This laptop is one of nicest machines I have ever owned and this is coming from a Mac enthusiast.	laptop one nicest machine ever owned Mac enthusiast
2	Form- It's beautiful.	form- beautiful
3	Espresso Black color is gorgeous and brushed metal look gives it a nice professional feel.	espresso black color gorgeous brushed metal look nice professional feel
4	A quick brown fox jumped over the lazy dog	quick brown fox jumped lazy dog
	Pre-specified separators : this, is, of, I, have, and, from, a, the, it, over, it's, has, that, coming

 

[mumps]

Try:

Option Compare Text
Sub RemoveWords()
    Application.ScreenUpdating = False
    Dim arr As Variant, i As Long
    arr = Array("This ", "Is ", "Of ", "i ", "Have ", "And ", "From ", "A ", "The ", "It ", , "Over ", , "It's ", "has ", "that ", "Coming ")
    With Range("B2", Range("B" & Rows.Count).End(xlUp))
        For i = LBound(arr) To UBound(arr)
            .Replace arr(i), "", xlPart, , False, , False, False
      Next i
    End With
    Application.ScreenUpdating = True
End Sub

 

[Peter_SSs]

@mumps
I know that you are basically following the given code, but I suggest that you try it with the text:
No sand in Atlanta or Memphis USA


@HowdeeDoodee
Your examples seem a little off.
Row 1 has machines but result has machine
Row 3 has gives but result does not even though gives is not in the separators list

However, you could also give this a try.**
I have assumed that data is in column B, starting at row 2 and results (for now) are going in to column C

**I haven't yet addressed the issue of the very large list of words that you envisage. How/where will the list come from?
Will they be entered directly into the code?
Will they be stored in a column in a worksheet? (If so, where?)
Something else?

Does your text have punctuation? I note that "." marks appeared in your samples but not in the results but there was no mention of them or any other punctuation.
Yet a "-" also appeared in the data and was not removed in the results.
Punctuation can make this sort of task difficult if not impossible to get 100% correct.

Sub Remove_Words()
  Dim RX As Object
  Dim a As Variant
  Dim i As Long

  Set RX = CreateObject("VBScript.RegExp")
  RX.IgnoreCase = True
  RX.Global = True
  RX.Pattern = "\b(This|Is|Of|i|Have|And|From|A|The|It|Over|It's|has|that|Coming|\.)( |\.|$)"
  With Range("B2", Range("B" & Rows.Count).End(xlUp))
    a = .Value
    For i = 1 To UBound(a)
      a(i, 1) = RX.Replace(a(i, 1), "")
      .Offset(, 1).Value = a
    Next i
  End With
End Sub

 

[mumps]

Hello Peter. I tried my macro using "No sand in Atlanta" and "Memphis USA". The "is" was removed from "Memphis USA" but the "and" was not removed from "No sand in Atlanta". ????

 

[Peter_SSs]

I tried my macro using "No sand in Atlanta" and "Memphis USA". The "is" was removed from "Memphis USA" but the "and" was not removed from "No sand in Atlanta". ????

My suggestion was actually for the complete text in one cell: "No sand in Atlanta or Memphis USA" because the "a" on the end of Atlanta is then also removed. I don't know why "and" was not removed from "sand" for you. Best guess is that there is something unusual about the space after "sand" in the cell text or the space after "and" in your code.

Here is what happens for me.

Before:

HowdeeDoodee 1.xlsm
	B
1	Sentence
2	No sand in Atlanta
3	Memphis USA
4	No sand in Atlanta or Memphis USA
Test

After:

HowdeeDoodee 1.xlsm
	B
1	Sentence
2	No sin Atlanta
3	MemphUSA
4	No sin Atlantor MemphUSA
Test

 

[mumps]

Thank you for that, Peter.

 

[HowdeeDoodee]

I have 1500 single words not in sentences. My preference is to put all those words in a column rather than in an array. I used someone else's example text because I thought the example would simplify things. Can someone give me code to process a column of single words in 850 sentences?

 

[Peter_SSs]

My preference is to put all those words in a column rather than in an array.

So the answer to my question ...

Will they be stored in a column in a worksheet? (If so, where?)

.. in 850 sentences?

So I guess the answer to my question is 'yes'?

Does your text have punctuation? I note that "." marks appeared in your samples but not in the results but there was no mention of them or any other punctuation.
Yet a "-" also appeared in the data and was not removed in the results.
Punctuation can make this sort of task difficult if not impossible to get 100% correct.

What further light can you shed on that issue?

 

[HowdeeDoodee]

Here is a picture of the actual sheet with the stop words in col A and the sentences in col B.

NewWordReplaceUsingMSWord (Autosaved).xlsx
	A	B	C
1	Find Stop Word In Adjoining Sentences	Sentences Containing Stop Words
2	_____	We all have our vanity wanting us to tell and show the world how powerful we are. Yet Christ calls us away from our vanity.	Words
3	_____	Few of the tasks of walking the Christian walk can be done without practice. When we make a mistake, we must pick ourselves up and start walking anew.	Characters
4	0s	What do you really desire? What do you really want? How much do you really desire? How much do you really want? Can you possess a lukewarm "sorta," "kinda," desire to live a godly life and achieve what God wants for you?	Sentences
5	3a	To never talk to God does not make sense.	Lines
6	3b	When you look back you can see the good and wonderful or the bad and the awful. You have a choice.	Paragraphs
7	3d	Christ always listens to your prayers, your petitions, and the pleas of your heart.	Numerals
8	6b	We need to rest our heart in the Lord's love.	Punctuation
9	6o	With the Lord's help, in His will, the broken fences of our past can be mended, new relationships built, and old relationships reborn.	Average Read Time
10	a	God has given you truly incredible gifts.	Average Spell Time
11	a1	We are all mistake-ridden sinners. However, Christ erases all our mistakes if we repent and accept Him as Lord of our life.	Pages (A4)
12	a2	Christ's suffering for you was meant to take away your searing pain.
13	a3	Placing your life in Christ's nail-scarred hands turns you away from bitterness and anger over past hurts and circumstances.
14	a4	Repentance is not only a process to confront your own wrongdoing, but also a process to confront the wrongdoing others have done to you.
15	ab	When we are honest, we are conquerors over the darkness trying to pull us down.
16	able	Praising God is a wonderful part of spiritual life.
17	about	The world still rejects our Lord Jesus. The world also rejects those of us who bring His love and message to the world. Yet, we carry on knowing He loves us and He has prepared a place for us.
18	above	Your actions still speak louder than words.
19	abst	Your acts of kindness and giving break down barriers surrounding a person caught up in the darkness.
20	ac	Take action against hatred, bigotry, insolence, and the haughtiness of evil by showing love, mercy, and kindness.
21	accordance	When you show acts of kindness, compassion, and love there is a thunderous ovation by the angels.
22	according	When you fail, glorify God by coming back with renewed spirit and new determination to be successful for the Lord.
23	accordingly	When you are willing to follow Christ, you no longer feel a desire to seek out human leadership.
24	across	In your daily walk, perhaps you are not permitted to speak about how wonderful the Lord is, but you can show Him.
25	act	Only God's way is the sure way.
26	actually	God lives within every living cell of our body. The Lord lives within our heart, mind, and soul.
27	ad	Many doors in life remain closed. The door leading you to Christ is always open.
28	added	We all need to put our sinful pride and ego aside.
29	adj	One of the more difficult things about being human is admitting our mistakes.
30	ae	We are to use our life to glorify God.
31	af	In worldly matters, we need to be smart, wise, and use our resources at hand for God's glory.
32	affected	We have no way to replace the hurt, pain, and humiliation of our past except with the love of Christ.
33	affecting	Far more important than surrounding yourself with friends is to be a friend…to be a friend of faith.
34	affects	We should be as reverent as Moses. We should understand we stand on holy ground.
35	after	Many of the tasks of the Christian walk require years of painful sacrifice.
36	afterwards	Satan wants us to shun any daily commitment growing our soul toward Christ. Christ wants us to embrace any daily commitment growing our soul toward Him.
37	ag	You cannot see the importance of your acts but God can. It is difficult to do, but try to see the importance of your life from God's perspective.
38	again	You cannot see the result of your life in the world. However, the result of your life is immensely important to God and to the world.
39	against	The light you shine in the life and heart of others ripples outward throughout the world.
40	ah	The blessings of God fall upon you when you unselfishly send His blessings out to others.
41	ain	Learn to live in peace, harmony, and love by surrendering all you are and all you have to Christ.
42	ain't	Some persons tragically have no way to measure their life or they try to measure their life with an open-ended funnel.
43	aj	When you are angry, even angry at God, talk to Him.
44	al	Some power over bad things is better than no power over bad things.
45	all	We should treat each other as if we value each other as much as Christ values us.
46	allow	Do not be hesitant about showing God's grace to the rude and crude for fear they will laugh at you. Even if they laugh at you, one or two of them may not.
47	allows	You cannot use what you do not know you have.
48	almost	We are children of God.
49	alone	When we are found, we are in the Great Shepherds sheepfold.
50	along	Christ beseeches us to plead with others around us to listen to the loving voice of our Lord.
51	already	Love demands we always follow Christ so we do not become lost.
52	also	No matter how old you are, nor the conditions under which you must live, getting better every day should be one of your top priorities.
53	although	No matter what the score might be on the scoreboard, our God reigns…and we win!
54	always	Christ's goal for you is for you to be His child, kneeling at the foot of His cross.
55	am	God will do great things for you if you do great things for God.
56	among	When we think we will never laugh again, there is the tickle of His love showing us we can laugh, live, and absorb His beauty after all.
57	amongst	When you give up the struggle to get as much as you want for yourself, you can then have a wonderful peace within your heart.
58	amoungst	When you give up struggling to go your own way and go Christ's way, you have His harmony within your soul.
59	amount	Stop trying to generate your own happiness in life because gratitude brings happiness.
60	an	Let Christ reign within you. Let Christ do His will within you.
61	and	When you let Christ reign within you, then you will have a love surpassing all human understanding.
62	announce	We know what God wants us to do when we see the pain, suffering, and hurt of life. He wants us to reach out and touch the hurting, help mend the broken, and support with prayer all those who need Him.
63	another	When we watch the sea roar with raging intensity, we must remember God is the creator.
64	any	When we see the power of a tornado easily whipping up trees as if the trees were matchsticks, we must remember God is greater than the power of the circling mass of energy.
65	anybody	Never undervalue your importance to God and to others.
66	anyhow	The simplest gestures of love and kindness often turn a life of darkness into a life full of God's light and love.
67	anymore	We often like change when we are young because change is a reflection of the growth and vitality of our maturation. However, when we get older, change becomes more difficult to accept.
68	anyone	God does not relish the fact you feel badly about mistakes you have made. God glories in your honesty.
69	anything	Make a special effort to come to know all God has given you.
70	anyway	Thinking poorly of yourself is the result of your ego twisted up to hurt you.
71	anyways	When we are lost, we are frightened, angry, and often bitter over our plight. However, when we are found, we are secure, happy, and we count each day as a blessing to be God's child.
72	anywhere	In this life, you remember the hurt, pain, and disappointment, but when the Lord touches your heart, the pain is erased.
73	ao	The touch of Jesus upon your heart helps you understand His sacrifice for you and helps you sacrifice for Him…even in the face of your terrifying fear.
74	ap	We all need to get along because we are all incredibly valuable to each other.
75	apart	Some questions for God are questions running deep into His ways, His reasoning, and His plans for which His answers must remain hidden from us.
76	apparently	Your actions of healing, reassurance, love, humility, and contrition help break through barriers of sin in others as well as yourself.
77	appear	In the world today, so many lives are caught up in the darkness. What so many people do not know is how the light and love of God dispels the darkness.
78	appreciate	People desperately need you to show them the love and peace only Christ can bring.
79	appropriate	The darkness of pain, suffering, and sin can be conquered by inviting the light of God in Christ into one's heart.
80	approximately	Wherever you go, whatever you do, at any time or place, inspire others with the love Christ has given you.
81	ar	The result of bringing Christ's love into the world can be fearful, for the world does not know Christ.
82	are	A miraculous event occurs when the true love of God fills your pain-filled empty heart.
83	aren	Each day you can listen to God call your name or you can listen to Satan's appealing call to turn away from God. You choose.
84	arent	You need others and others need you.
85	aren't	God loves the heart of a person who wants to win under His rules and guidelines.
86	arise	Christ's touch erases the fear and dread put upon you from terrible people or terrible circumstances.
87	around	In love, we do not see how we are better, or bigger, or stronger, or richer, or taller because in love we are continually expressing our joy in humility.
88	as	Love engenders Christ-like humility in us by enabling us to reject the idea of being better than someone else.
89	a's	There is no bragging in love because love is "others" oriented.
90	aside	To boast means we are deficient.
91	ask	With love, there is no deficiency, only an overflowing of heart, mind, and soul.
92	asking	In a world dominated by greed and selfishness, love finds a way to complete tasks and get jobs done more efficiently.
93	associated	Self-seekers end up being their own worst enemy.
94	at	In your life, the more you look out for the interests of others, the more successful you will be.
95	au	Love demands we live a life of hope.
96	auth	Because of Christ, for every person on earth, the future is full of promise even when the present is shrouded in darkness and disaster.
97	av	Your world loves a show. However, God is not in show business.
98	available	The people in your world need you to encourage them and give them support. The same kind of support Jesus gives.
99	aw	When you encourage others, you show the strength of Christ in your life.
100	away	As wrong as much of life can be, if we are patient, in the end, God will make all things right, all things new, and all things as they should be.
101	awfully	As we draw close to God when we are hurting, He fills our hurting heart with a peace, understanding, and love not found on earth.
102	ax	In everyday life, we do not encounter ghosts or a walking Jesus on the lake. However, we do encounter many frightening things keeping us from doing and being all God wants us to do and be.
103	ay	The easy path of sin can lead to a darkness for which there is no end.
104	az	When we see how much Christ loves us, how can we not love Him back enough to give our life to Him?
105	b	Love has a way of multiplying itself in mysterious ways…overflowing with love…you must give love away.
106	b1	Love has a way of letting things happen in God's time.
107	b2	Salt is used both as a seasoning and as a preservative. As Christians, we are to be the salt of the earth.
108	b3	You are amazed and perhaps entertained by seeing the power of faith working in persons lives. Remember the power and the actions of God go largely unseen and unknown.
109	ba	No matter how much material wealth you acquire or come to own, material things are not enough.
110	back	Your real reward comes to you as Christ welcomes you into your new mansion in Heaven.
111	bc	The healing grace of Christ cannot be measured by any human standard.
112	bd	When we boast, we tragically ignore others as we puff up ourselves.
113	be	Love for others and love for God dissolves the ego.
114	became	With love, we come to understand position, power, authority, and material things are of no value.
115	because	With love, we come to understand only Christ is of value.
116	become	With love, we are not stuck up because we are willing to take a lesser road or a lesser position.
117	becomes	When we come to the Cross and we look upon our Savior, we are crushed. Then He touches us and we see eternity waiting for us because of Him.
118	becoming	You can desire to always live a devout and righteous life. When you have these longings and desires, you become one with God.
119	been	When we think about the will of God, we already know on a minute to minute basis we are to kneel at the foot of the Cross, while displaying His love and compassion to the world.
120	before	To receive help from God, we must cast aside our ego, our wants, our pride, our selfishness, and our sin.
121	beforehand	We can know what God's will for us is when we come to deal with other persons, when we come to deal with Him, and when we are confronted with sin and corruption.
122	begin	When bad things happen and doors are closed, one Door is always open.
123	beginning	Nothing helps us come closer to God than making an admission of our failure before Him.
124	beginnings	To find fault with yourself because of your sin is to make the condition of your sin problem worse than your problem needs to be. Repentance is the solution.
125	begins	God does not make demands upon you unless His demands are for your own good.
126	behind	God creates new things. God has created old things. God is the creator of all things.
127	being	The spiritual truth about your life and your world is this…you have an eternity waiting for you.
128	believe	Your real reward is in Heaven, not on earth.
129	below	Trusting God means you trust Him enough to give Him your life.
130	beside	When you are lost and cannot find your way home, God is your constant guide and your compass.
131	besides	Even when people go astray, as sheep wander off into places they do not belong, people who go astray are to be loved just as Christ loves us.
132	best	When God's power of love comes over a person's life, all the things of earth, the things we think are so important, seem to pass away.
133	better	Love does not have time for pride because love is too busy helping others, supporting others, and glorifying God in all we say and do.
134	between	Love is not rude because in love we tend to the needs of others.
135	beyond	Love knows the ways, outcomes, and thoughts of others.
136	bi	Love provides a way for us to function regardless of our environment or condition.
137	bill	In a time of grief, our first instinct should always be to run to God for His healing, comfort, and consolation.
138	biol	God is still creating even when your free will gives you the idea God is asleep, dead, or does not care enough to interact with you.
139	bj	God gave you a will, a free will, to be used to make decisions about the circumstances in your life.
140	bk	The living force you call life, and all the particles making up the chemicals of your universe, came from God.
141	bl	What a wonderful God we have. What a wonderful God we serve.
142	bn	When you break or violate the rules of God there are always penalties.
143	both	Knowing the rules for living our Lord placed within His Word and within your heart is critical to leading a godly life.
144	bottom	The Lord provides you with the hope to fuel your life.
145	bp	At the Cross, we find strength to resist Satan and Satan's dark ways.
146	br	When anger floods your heart and mind, let the living water of Christ's love fill your life.
147	brief	With the Lord's help, you can clean up your mistakes.
148	briefly	Our greatest resource in life is God the Father, Jesus Christ the Son, and the Holy Spirit.
149	bs	Putting yourself down is a form of distorted selfishness.
150	bt	When you do what Love demands, no matter what happens in your life, Christ will always be with you as your treasured friend.
151	bu	There are no words to describe the infinity and magnitude of our Lord.
152	but	We must always remember to keep a balance in our life.
153	bx	Although you may not know it, people depend upon you to show Christ's light and His truth.
154	by	The circumstances of your life can be depressing until you start to think, pray, and meditate upon Christ and your future with Him.
155	c	If you let your heart melt at Christ's touch, you can be His instrument of peace.
156	c1	There are times of grief when it seems grief will never end. There are also years and seasons when joy abounds.
157	c2	When we look backward in sadness or grief, we strain our necks.
158	c3	The consequences of disobedience to God are severe.
159	ca	The Lord will provide you with the wisdom you need.
160	call	Jesus is the Light of the world.
161	came	When your mind is attuned to the Holy Spirit, you are truly able to be in control of your life circumstances.
162	can	Love bubbles up out of our heart to inspire others. Love bubbles up out of our heart to lift others regardless of their state in life.
163	cannot	When we are continually giving, we have no need or passion to take from others.
164	cant	Love fills our craving for material things thereby empowering us to make do with what we have.
165	can't	Love overrides the desires of our heart so easily tempted by satanic darkness.
166	cause	We are not puffed up when we are within God's love.
167	causes	The dazzle of a spectacular show ends. Love goes on forever.
168	cc	Another way of expressing God's goal for you is to speak about God's will for you.
169	cd	If we had our own way, every time we called on God for help, He would deliver what we want, like we want it. However, our way is not important to God. God's way is important to God.
170	ce	The truth sets us free but we are too often afraid of the truth.
171	certain	Trusting God means you give Him all you have.
172	certainly	All people, even those who have power and wealth, will die. However, we have protection from death through Christ who died to give us eternal life.
173	cf	True Christian love within your heart does not use others to any advantage. Love sacrifices personal advantage to advance the life of others.
174	cg	You must do the hard work of building your church and your Christian community.
175	ch	The simplest smile, the smallest gesture, and the smallest touch can mean so much.
176	changes	Love is not always consumed with the idea of wrong because love is consumed with making things right.
177	ci	When we are reborn in Christ's love we have a new spiritual body disdaining the sinful things of this earth.
178	cit	When you invite Christ into your life, a stream of living water pours down from heaven into your heart.
179	cj	When your heart awakens to the outpouring of His love and grace, give Him thanks.
180	cl	God's way to give each of us a new eternal dawn in our life was to send His only Son into the world to die for us.
181	clearly	With the love of Christ welling up within us we have a fountain of living water within us…a fountain of living water filling our soul giving us a peace we cannot easily explain.
182	cm	When you pray, try to let God speak to you by being silent before Him.
183	c'mon	Too often, we are not silent with God. With God, we speak instead of listening to Him tell us how much He loves us.
184	cn	Age can bring with it a time in life full of counting the blessings God has poured out upon you.
185	co	Instead of waiting on God to serve you, in relentless devotion your heart must always be serving Him.
186	com	Be aware! The world entices you away from your faith.
187	come	Over the years, we can lose track of people or we only write to them in our Christmas cards. Let us not forget them. Let us pray for them each day.
188	comes	Christ came into the world to erase the awful shame and humiliation you may have experienced.
189	con	Christ came into the world to tell you hard work produces fruit for the Kingdom of God and fruit within your life.
190	concerning	Christ came into the world to get you to learn to do new things in new ways. Christ came into the world to get you to do old things in new ways.
191	consequently	Christmas is a time to reaffirm your desire to live according to Christ's greatest commandment…to love God with all your heart, all your soul, and all your might.
192	consider	The pain of your heart is pushed out by Christ's love and compassion.
193	considering	Whether you work for wages or not, you get paid in the end according to the Lord's righteous judgment.
194	contain	The infinite love of Christ can never be fully known or fully understood by us while we are alive on earth.
195	containing	Living in total humility on earth begets for you a beautiful applause on the other shore.
196	contains	When you think thoughts of love and kindness, peace will reign within you.
197	corresponding	Today, let the pouring out of Christ's love, mercy, compassion, and presence be your guide in leading a life in Christ's name.
198	could	Every day we see reasons why we believe Christ will return to us while we are alive upon the earth.
199	couldn	God is forming, shaping, and molding you, if you let Him.
200	couldnt	God cannot be measured, sized, or gauged.
201	couldn't	Look deeply into the lives of those who seem to have it all and you may find they have very little.
202	course	Living in thanksgiving gives an ability to see small flickering lights of love in the hearts of little children.
203	cp	Others inflict wounds upon us and our heart is torn. However, we serve a Great Physician who can heal our heart forever.
204	cq	All have shinned and fallen short of the glory of God. However, Christ came to stand with us and be our Intercessor so when we fall short, He will be with us to cover our mistakes.
205	cr	It is easy to slip away into the sinful part of the world. However, God has given each of us a will to turn away from sin.
206	cry	If we are not honest about the wiles of Satan in our life, our self-lies will doom us.
207	cs	Christ's birth means your heart can be made new because you can be reborn.
208	c's	Jesus was born so your selfishness would be replaced by unselfishness, causing your unhappiness to be replaced by happiness.
209	ct	Jesus was born to make God's will your will.
210	cu	Jesus was born to take away your fear of death as you accept Him.
211	currently	In the warmth of Christ's manger, remember you have not received even a fraction of your real reward to be found in Heaven.
212	cv	Many times we must be a warrior, but we are not alone because Christ is with us.
213	cx	The kind of people we bring into our life determines the ease or difficulty of our life.
214	cy	Perhaps in your life you know you need to bring the knowledge of Christ to someone but you are afraid to act. Take courage and act.
215	cz	No achievement of merit happens without a passion to achieve.
216	d	No victory for Christ is ever won without a burning desire to serve Him.
217	d2	You can have a heart desiring to be one with Christ.
218	da	Even when you cannot control every circumstance and event in your life, you can display reasoned responses to circumstances.
219	date	When you exert all your energies to be holy and devout, you are able to push all satanic forces aside because you have the Holy Spirit helping you battle against the darkness.
220	dc	You can control whether you pray or do not pray. What will you do?
221	dd	You can control whether you surrender your life to Christ or keep your life for yourself. What will you do?
222	de	With the self-control you have, you can let your mind be touched by the Holy Spirit.
223	definitely	Let us all be busy doing work for the Lord.
224	describe	The Lord's will is for you to be industrious, to create, and to build according to His will.
225	described	Learning about the Lord and learning about your world should be a daily life-long endeavor.
226	despite	There are times when righteous anger is justified, but righteous anger does not mean anger is just.
227	detail	Not everyone is privileged to see an angel. However, all the people in your life are privileged to see you, a person who can do angel work.
228	df	If you are willing to do so, you can look back and see the Lord's hand in your life.
229	di	In every dark hour, when you need someone, you have Christ.
230	did	The fullness of your life depends upon what you do with the blessings God gives you.
231	didn	If you only commit your life and energy to yourself, you may not surround yourself with persons will carry you when you need to be carried.
232	didn't	Tragically, we want what we want and need, and we want it now! However, patience is golden, and waiting can bring treasures.
233	different	We all know things and situations in the world are not what they should be. However, there is a place of utmost perfection. This place of perfection is God's home now, and your home later on.
234	dj	God wants to create a new life within each person who walks the earth.
235	dk	Within the heart of sinful men and women, within the deepest recesses of the darkness where we plot against others to hurt or destroy…there is an empty place where the Light could live…what will we do?
236	dl	In our times of joy or sadness, we have a wonderful Lord and Savior who reveals the twinkling stars and the bright moon.
237	do	Christ came into the world to give you the gift of erasing the awful shame and humiliation you may have experienced.
238	does	Christ came into the world to give you the gift of knowing hard work produces fruit for the Kingdom of God and fruit within your life.
239	doesn	Christ came into the world to give you the gift of His teaching you to do old things according to His will.
240	doesn't	Christmas is a time to reaffirm your desire to live according to Christ's greatest commandment…to love God with all your heart, all your soul, and all your might.
241	doing	No matter what the season of the year may be, the pain of your heart is pushed out by Christ's love and compassion.
242	don	Love within you has a way of touching others with a power to quell the rage within them.
243	done	Love within your heart defends the defenseless.
244	don't	Your love shelters the children and adults of every faith, whether there is a disagreement over issues or not.
245	down	We often wonder why God does not speak to us or speak with us. Perhaps we should wonder why we have ears yet we do not hear.
246	downwards	We go to God with our minds full of words and thoughts. Let us go to God with our minds full of desire wanting to glorify Him.
247	dp	We can give Christ an incredible gift by giving Him our spirit of obedience.
248	dr	Our lives are filled with priorities. Let us keep as a priority the keeping of Christmas all year round within our heart and soul.
249	ds	Every day, give Christ the gift of getting better at being His child.
250	dt	We should value each other as much as we value the birth and resurrection of Christ.
251	du	During the Christmas season, or any season, when you are unselfish, then happiness is the result.
252	due	We all stand in Christ's presence. If we are willing, we can be washed clean and redeemed by His blood.
253	during	Live a life of devout godliness. You will be paid in heaven for your hard work of staying true to the calling of Christ upon your life.
254	dx	If we do not get to see Christ's return to earth while we are living, we will live to see His return to earth with a better view from Heaven.
255	dy	When you talk to God, He listens.
256	e	No matter what you have done, no matter what mistakes you have made, no matter what…you can talk to God…and He listens.
257	e2	The order of all things was established by God at the moment all things were created. Then, when Satan entered God's creation, chaos appeared.
258	e3	The disorder of life is a result of Satan's attack.
259	ea	When you are willing to put your life into Christ's nail-scared hands, then all of the disorder and the disharmony of life fades away.
260	each	When you surrender your life to Christ, many things make sense for the first time because His order is established in your life.
261	ec	Humanity seeks a leader in all the institutions humanity creates. Terribly, humanity makes tragic mistakes.
262	ed	You can long to only display Christ's love and compassion to others. When you have this longing, He will live within your heart and life.
263	edu	Happiness does not come to you via the mail or by telephone. Happiness is the result of the kind of person you are.
264	ee	The love of Christ makes all things new. The love of Christ puts all things into God's proper order.
265	ef	As a follower of Christ, do not be surprised when others think ill of you or speak unkind things about you.
266	effect	Starving souls display acts of silent desperation often seen as a frown, a deep sigh, or a verbal disdain of God's love.
267	eg	All of us can glorify God, even when we are exhausted and beaten down.
268	ei	In the silence of our response to changes in life, we can send our heart and prayers to God, asking Him to use us in every changing circumstance.
269	eight	In a world of change and chaos, we have an unchanging and constant God.
270	eighty	The bonding in our relationships adds great substance to our life.
271	either	The persons we take for granted, like our friends and family, can give us contact with the love we call God.
272	ej	The Lord has a big eraser ready to erase the hurt, pain, humiliation, and disappointment of your life.
273	el	We walk our path of our faith without fully knowing all God is and wants from us. Yet we walk in love.
274	eleven	We may not be able to see into the future to see how future events will unfold. Yet if we look far enough, we can see Christ Jesus waiting for us.
275	else	Persons in darkness need you.
276	elsewhere	No matter what kinds of frustrations appear in your life, love erases them.
277	em	Through Christ, we can be empowered with confidence when we are weak-kneed and ridden with anxiety.
278	empty	We serve a mighty God who requires our humble service, yet this same God who requires we be humble, also requires we open our heart, mind, and soul to His power that makes our imagination soar.
279	en	Our mighty God comes to us in our hour of greatest pain. He tickles our funny bone. He infuses us with optimism and hope when we feel all is lost.
280	end	Whether we live in a poor rundown neighborhood or a mansion in Beverly Hills, we need not be separated from our God who loves us beyond measure.
281	ending	We often ignore God and we do not speak to Him enough. However, He always seeks to speak to us as He tries to pour His truth and wisdom into our heart.
282	enough	We seek leaders in government, business, education, science, medicine, philosophy, and religion. Do we seek leaders who are men and women of God?
283	entirely	You can make a conscious choice to build up or encourage all the persons around you.
284	eo	You can choose to support organizations providing employment.
285	ep	Anger, like a tornado, is a rage of emotion running through us that can destroy us and those around us.
286	eq	You can choose to support the church where you find messages of Christ's love.
287	er	Every human being will die. Even Jesus, who was God made into man, physically died. However, every human being has a chance to live forever because Christ lived, died, and came back to life for each of us.
288	es	We live in such a rapid age we expect a quick fix for anything that goes wrong.
289	especially	We live in an age of childish impatience.
290	est	When Satan brings us down, we may have little heart left to praise God. Although our praise voice may be quieted, we can still reach up to His nail-scarred hand.
291	et	When we are attacked by the darkness of the world, we must carry our burdens to Christ as we kneel at the foot of His Cross.
292	et-al	As persons of faith, we must continually take our life to Christ.
293	etc	When we admit our failures, we bring joy to Christ's heart. Then we can experience His joy within us.
294	eu	If you gave someone a wonderful gift but the person never bothered to open the package, wouldn't you be a bit upset? In the same way, God has given you many gifts yet to be opened.
295	ev	In wisdom, when we need help, it is smart and astute to get the help we need.
296	even	We carry His kingdom within us.
297	ever	Be the salt of the earth by giving love, giving understanding, and shining the light of Christ's truth into the heart of others.
298	every	God loves you deeply and with such force only your surrendered soul can take it all in.
299	everybody	When you give in love, the gift becomes larger than yourself. Angels then sing the praises of your Savior.
300	everyone	When you silence your mind and quiet your heart, you give Christ a chance to fill you with His love and grace.
301	everything	Advancing age can put you on new ground to glorify Him hour by hour.
302	everywhere	Even when there is an opportunity for righteous anger, we must remain at peace.
303	ex	Just about everyone asks God to give answers to questions. However, many of the answers we seek are already known to us.
304	exactly	Most of the questions we have for God have already been answered in God's Holy Word.
305	example	If you seek with your mind and heart, many of the questions you have for God have an answer in how nature and life are organized.
306	except	We must learn and be content with the fact not all questions we give to God will get an answer.
307	ey	It is just like Jesus, in all His wonderful ways, to give us His gift of forgiveness while His earthly life was about to be taken from Him.
308	f	Perhaps tomorrow will be the day.
309	f2	When there is no plan for the future there is only a haphazard and accidental result in living our life.
310	fa	It makes no difference about what you see when you look backward because looking backward is not what you are supposed to do. What you are supposed to do is look forward.
311	far	When we cast aside the parts of us separating us from God, He then helps us in ways we cannot imagine.
312	fc	Material things do not fill the soul. Only Christ can fill your soul.
313	few	[XD]
Sheet1

 

[Peter_SSs]

As I mentioned before, punctuation is a problem for this sort of code and you have plenty of it, including at least . , ? "
You also talked about having "words" in column A but you have some very strange looking "words" in there.

In any case, you could give this a try with a copy of your data. It still puts the results in column C so that you can compare the original text to the new text.

Sub Remove_Words_v2()
  Dim RX As Object
  Dim a As Variant
  Dim i As Long
  
  Set RX = CreateObject("VBScript.RegExp")
  RX.IgnoreCase = True
  RX.Global = True
  RX.Pattern = "\b(" & Join(Application.Transpose(Range("A2", Range("A" & Rows.Count).End(xlUp)).Value), "|") & ")( |\.|\?|\!|$)"
  With Range("B2", Range("B" & Rows.Count).End(xlUp))
    a = .Value
    For i = 1 To UBound(a)
      a(i, 1) = RX.Replace(a(i, 1), "")
      .Offset(, 1).Value = a
    Next i
  End With
End Sub