1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel - how to make a cell truly blank?

Discussion in 'Business Applications' started by holly00, Jul 28, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. holly00

    holly00 Thread Starter

    Joined:
    Jul 27, 2007
    Messages:
    26
    How can I use a formula to make a cell truly blank?

    The only way I know is to use =IF(ISBLANK(A2),"",A2)
    but although if A2 is blank, the new cell appears blank, Excel treats these cells as if they contain text.
    When you sort cells containing formulas that return empty double quotation marks, they are placed above blank cells.

    Is there any way to create truly blank cells with a formula or function so they are sorted as blank cells at the bottom in both ascending and descending order?
    Thanks,
     
  2. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/601674