Deleting specific words

T

thewiseguy

Well-known Member
Joined
May 23, 2005
Messages
819
Office Version
  1. 365
Platform
  1. Windows
Hello again,

I want to delete only the word "township" in a list and not all cells in the list contain this word. Is there a quick formula for this?

tia.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

E
  • Question
Partial deletion
Replies
5
Views
140
Peter_SSs
Peter_SSs
F
  • Solved
VBA Code to Open a Word Template and Delete Bookmarks and Enclosed Text Based on the Value in Excel Cells
Replies
5
Views
1K
Fromlostdays1
F
A
  • Question
Deleting Rows VBA
Replies
2
Views
226
rollis13
rollis13
T
  • Question
I am needing help making a macro that will save me time in my job
Replies
0
Views
480
TcHawker
T
Ottsel
  • Solved
Delete Rows That Do Not Contain a Certain Phrase
Replies
6
Views
339
johnnyL
J

Forum statistics

Threads
1,191,032
Messages
5,984,241
Members
439,879
Latest member
KingGoulash

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top