Find a string in Excel and remove all cells [Solved/Closed]

Report
Posts
2
Registration date
Thursday July 2, 2009
Status
Member
Last seen
July 3, 2009
-
 Ex-Q?? -
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
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
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 .....

3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5774 users have said thank you to us this month

davidarth
Posts
2
Registration date
Thursday July 2, 2009
Status
Member
Last seen
July 3, 2009

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).
you can do a Search eg Search({"Your text"},Cell,start posn)

Hope it helps