MS Excel help

B

breakout51

I want to delete specific values from a column in excel, without deleting the cells themselves i.e the contents of the cell if the content meets certain conditions.
In my case I have a column of almost 0.5M cells & I want to delete the contents from the cells which contains the word "Impact" without deleting the cell itself.
 
C

Claus Busch

Hi,

Am Thu, 28 Feb 2013 06:42:13 -0800 (PST) schrieb (e-mail address removed):
I want to delete specific values from a column in excel, without deleting the cells themselves i.e the contents of the cell if the content meets certain conditions.
In my case I have a column of almost 0.5M cells & I want to delete the contents from the cells which contains the word "Impact" without deleting the cell itself.

do it with replace:
find what: Impact
replace with: (nothing)


Regards
Claus Busch
 
C

CellShocked

Hi,

Am Thu, 28 Feb 2013 06:42:13 -0800 (PST) schrieb (e-mail address removed):

deleting the cells themselves i.e the contents of the cell if the
content meets certain conditions.
the contents from the cells which contains the word "Impact" without
deleting the cell itself.

do it with replace:
find what: Impact
replace with: (nothing)


Regards
Claus Busch


If "Impact" is the only thing the cell contains, right?

Otherwise, it simply chops that term away from the cell's contents?

So maybe: A find, then do a cell ID thing, then a 'clear contents' of
that ID thing to clear the entire cell value, but leave the formatting.
Then repeat.

No?
 
C

Claus Busch

Hi,

Am Fri, 01 Mar 2013 03:39:44 -0800 schrieb CellShocked:
If "Impact" is the only thing the cell contains, right?

it is different whether you find in whole cell or in part of cell
Otherwise, it simply chops that term away from the cell's contents?

If you search in part of cell, a find clears the whole cell
So maybe: A find, then do a cell ID thing, then a 'clear contents' of
that ID thing to clear the entire cell value, but leave the formatting.
Then repeat.

I meant Home tab => Find and Select => Replace, not VBA


Regards
Claus Busch
 
J

joeu2004

In my case I have a column of almost 0.5M cells &
I want to delete the contents from the cells which
contains the word "Impact" without deleting the cell
itself.

With Find (press ctrl+F), enter "impact" (without quotes) into the Find What
field, and click on Find All. With at least one result selected, press
ctrl+A to select the entire list. That will select the cells that contain
the word "impact". Close the Find dialog box, then press Delete to clear
the contents of the selected cells.

Caveat: I have never tried this with as many as 500K cells. I don't know
if Excel has a limit on the number of selected cells.
 
C

CellShocked

, then press Delete to clear
the contents of the selected cells.

You do not read very well.

That is exactly what he does NOT want to do.

He wants to retain the cell's formatting.
"Clear Contents" is needed or "replace".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top