Search : in
By :

Find a string in Excel and remove all cells

Last answer on Jul 3, 2009 10:13:29 am BST davidarth, on Jul 3, 2009 9:24:03 am BST 
 Report this message to moderators

Hello,
I need to find a string (for example: abc) in a large worksheet then remove all cells containing this string. I have tried different functions but didn't work. Can anyone help me? Thanks.
David

Best answers for « Find a string in Excel and remove all cells » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Download Advanced Find&Replace for Excel ShowDescription This application is designed by Add-in Express LTD. Advanced Find & Replace is an add-on for Microsoft Excel. It allows you to run multiple searches for values, formulas and comments. The search results are displayed in a floating...
Download Excel Viewer ShowExcel Viewer 2003 will allow you to open, view and print spreadsheet workbooks though you do not necessarily have to install Excel on your computer. Features: It will allow you to make a copy of the information found in Excel Viewer 2003 and...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

mubashir aziz, on Jul 3, 2009 9:51:39 am BST
  • +1

You can select all columns in work sheet then press Ctrl+H to replace and then in Find What bar write abc and in replace with bar write nothing and press ok all abc will be vanished from the work sheet ....

It depends that are you talking that entire cells have this name like A1=apple , B5=apple then above command will easily blank the cells ....

But it you are talking that text any where in the cells then there will be need of a macro like you want to say cell contain an apple , good apple then you want whole cell to be blank then this command will not work as per your needs .... more over this command will replace all apple even if there are applet then it will remove apple and only t will be remaining .....

It totally depends on you needs .... please be more specific to define your problem .....

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz

2

 davidarth, on Jul 3, 2009 10:13:29 am BST

Thanks. I want to find a string in all characters of a cell and all cells like this. Your solution is not for me but thanks. I have worked it out using FIND("abc",A1).

   
Reply to davidarth
Ask your question Reply
They need your help