Solved

testing for blank cells

Posted on 2011-02-17
2
561 Views
Last Modified: 2012-06-22
Other than writing some VB code.  Is there any way to set a cell blank thru an if statement (ie if a - set value to X if B set value to ???).   I need to later test the value in the cell to if it has an X or is empty.  Unfortunately I have test all the IS functions and none of them can distiquish between " " and a letter.  That is even though the cell looks empty ISBLANK returns FALSE and ISTEXT returns true.  What can I put in the cell that is not visible but is not considered TEXT and or is considered truly blank.
0
Comment
Question by:dma70
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
sunezapa earned 125 total points
ID: 34922305
will LEN(<cell>) do it? f.ex. LEN(A2) and eventually combining the statements...
0
 
LVL 1

Author Closing Comment

by:dma70
ID: 34997121
That was easy -- sorry for taking so long to reply -- I was on vacation for the week.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question