Solved

testing for blank cells

Posted on 2011-02-17
2
542 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
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Use System DSN 6 87
SCCM 2012 Report 8 153
Inplace uprade from 08' to 12' R2. KMS server keys no longer working. Please help! 6 235
Where is user Lync data stored 4 86
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
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…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

778 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