Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Search Search
Search for:
Tech Support Guy > > >

Excel - how to make a cell truly blank?


(!)

holly00's Avatar
holly00 holly00 is offline
Junior Member with 26 posts.
THREAD STARTER
 
Join Date: Jul 2007
Experience: Intermediate
28-Jul-2007, 01:37 AM #1
Excel - how to make a cell truly blank?
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,
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
28-Jul-2007, 03:12 AM #2
Holly, check out my response in the other thread you started:
http://forums.techguy.org/business-a...ata-sheet.html
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑