Find a string in Excel and remove all cells
Solved/Closed
davidarth
Posts
2
Registration date
Thursday 2 July 2009
Status
Member
Last seen
3 July 2009
-
3 Jul 2009 à 04:24
Ex-Q?? - 25 Feb 2010 à 10:50
Ex-Q?? - 25 Feb 2010 à 10:50
Related:
- Find a string in Excel and remove all cells
- Excel mod apk for pc - Download - Spreadsheets
- How to remove formatting in excel - Guide
- Excel count occurrences of string in cell - Guide
- Excel vba find - Guide
- Arrow keys not working in excel - Guide
2 responses
mubashir aziz
Posts
190
Registration date
Sunday 12 April 2009
Status
Member
Last seen
16 February 2010
166
3 Jul 2009 à 04:51
3 Jul 2009 à 04:51
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 .....
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 .....
3 Jul 2009 à 05:13