Blank cells

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
 
M

Myrna Larson

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.
 

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

Publisher adding blank page when printing my booklet... 2
How to display zero value in blank fields of Cross Tab query 0
Mail Merge Switch - Dollars to Words 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Pivot Table cell values 1
Newbie Help - IF Yes No Function 0
Concatenate a row that is selected and include blank cells 11
Blank Page After Envelope-Label Wizard 5

Top