<div>
That was easy -- sorry for taking so long to reply -- I was on vacation for the week.
</div>


That was easy -- sorry for taking so long to reply -- I was on vacation for the week.

<div>
<div class="content wysiwyg-content">
Other than writing some VB code. &nbsp;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 ???). &nbsp; I need to later test the value in the cell to if it has an X or is empty. &nbsp;Unfortunately I have test all the IS functions and none of them can distiquish between &quot;&nbsp;&quot; and a letter. &nbsp;That is even though the cell looks empty ISBLANK returns FALSE and ISTEXT returns true. &nbsp;What can I put in the cell that is not visible but is not considered TEXT and or is considered truly blank. 
</div>
</div>


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. 

testing for blank cells

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.