MS Excel help

  • Thread starter Thread starter breakout51
  • Start date Start date
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.
 
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.
Click to expand...

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


Regards
Claus Busch
 
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
Click to expand...


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?
 
Hi,

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

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?
Click to expand...

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.
Click to expand...

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


Regards
Claus Busch
 
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.
Click to expand...

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.
 
, then press Delete to clear
the contents of the selected cells.
Click to expand...

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".
 
Back
Top