CLICK HERE FOR SOURCE
Find a string in Excel and remove all cells
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 .....
No comments:
Post a Comment