MS Excel help

[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.

 

[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

 

[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?

 

[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

 

[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.

 

[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".

 

[joeu2004]

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

You do not read very well. [....]
He wants to retain the cell's formatting.

And Delete does exactly that.