Blank cells

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Please help,
I want to convert cells with zero or other values to
blank, so that they are not included in sorting.

Thanks

Rounak
 
Assuming the cells contain literal values (as opposed to the 0's being the result of formulas),
use Edit/Replace, Find What -- 0, Replace With -- leave blank. Do the same for other values.
 
You must log in or register to reply here.

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

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Substituting zero values in blank cells 5
Excel Concatenate with line breaks but ignore blank cells 3
Concatenate a row that is selected and include blank cells 11
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Excel formula, sum the value cell and if empty cell left blank 0
Blanks -> 0 code 2
Format cells help 2

Back
Top