Deleting rows [Anwsered]

Deleting rows

Hi, I would like to enquire about Excel 2010:

Can I delete the whole sentence if specific word is found?
Let's say I have them in different rows:

1) what to do now
2) what is she doing here
3) please do help to post the thing
4) is he working

It appears that 1 & 3 contains the word 'do', is there any way I can choose to delete the row or box that contains 'do'?

So what's left would be 2 & 4, and then automatically delete the empty row, so the clean list now would be

1) what is she doing here
2) is he working

Thanks in advance!

Keys to the Problem Deleting rows

Download SmartPCFixer to Fix It (Free)

Hi,

Welcome to Microsoft answers.
Before I have an attempt to answer your question I note you posted this question in another thread.
I split that question off from that thread to make it a separate question before I noticed you posted here.
As your very new
to this forum maybe now would be a good time to have a look at the code of conduct, particularly the
Please Don't section.


http://answers.microsoft.com/en-us/page/faq#faqCodeConduct

Now to your question, try this macro.
Note in the coe some comments changes you may have to make

Sub delete_Me()
Dim MyColumn As String, Lastrow As Long
Dim x As Long, DelString
'Change this to the correct sting to look for
DelString = "Do"
'Don't change this line
DelString = " " & DelString & " "
'Change this to the column with the data on
MyColumn = "A"
Lastrow = Cells(Cells.Rows.Count, MyColumn).End(xlUp).Row
For x = Lastrow To 1 Step -1
    If InStr(1, " " & Cells(x, MyColumn).Value & " ", DelString, vbTextCompare) > 0 Then
        Rows(x).Delete
    End If
Next
End Sub

Use the System File Checker tool to repair corrupted or missing system files:

1. Click Start.
2. Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
3. The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
4. Type or copy paste the below command line into it without quotes:
5. "Sfc /scannow"

Recommended Method to Repair the Problem: Deleting rows:

 

 

How to Fix Deleting rows with SmartPCFixer?

1. Download Error Fixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.

Related: Corrupt partition can t boot Windows 7 Startup Repair Fails asus support Dual booting Windows 7 Professional and Windows 7 Ultimate TermService running but Remote Desktop not connected asus drivers I have Windows 7 Screen goes dark and will computer will not funtion asus support Shortcut keys will lock me out on Windows 7 Home Premium asus mainboard driver download SSMMgr exe has stopped working a problem caused the program to stop working correctly Windows will close this program and notify you if a solution is available 2 days Error Could not find the macromedia flash asus mainboard driver download where do I get the ioport sys driver that I need for Windows 7 asus driver Your version of Windows SharePoint Services 3 0 isn t compatible with this version of Windows asus drivers 1 Flip off the laptop. Turn it over onto its cover so that you can accessibility the back panel.,Can one teach Windows 7 to do copying of large files in the background realtek pcie gbe family controller driver Dell xps 9000 running Windows 7 CTRL key is locked regardless of different keyboards connected realtek driver download passwords for login on websites no longer work since switching to Windows 8 realtek drivers windows 7 Shutdown and Logon Issue Windows 7 Realtek Audio Drivers Windows XP Start Windows Media Center automatically when Windows 8 1 starts www realtek com tw Windows 7 not allowing me to connect to my wireless router realtek pcie fe family controller driver Wireless Network Connection Problems on Windows 7 realtek driver download Realtek LAN Driver DOWNLOAD
Read More: Solution to Error: Window experience index crash,[Solution] How can I be sure I have no more charges?,Yahoo redirects to yahoo search [Solved],Troubleshooter of Error: How do I change my e-mail address, I believe the one I have has been stollen,Troubleshooting:need driver for a windows 7-64 computer to run a hp photosmart 7760 printer Error,Backup 'change Settings" "Back up now" and "turn on schedule" do not function properly,Backup fails to complete, there is some I/O device error,XP Labors Heavily and Will not Start (sometimes even in safe mode. And if it starts in SM, it will freeze when I try to get in to change anything.),MS Windows Back up failing,How to Use Report Filter to Filter on Value