• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 579
  • Last Modified:

testing for blank cells

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
dma70
Asked:
dma70
1 Solution
 
sunezapaCommented:
will LEN(<cell>) do it? f.ex. LEN(A2) and eventually combining the statements...
0
 
dma70Author Commented:
That was easy -- sorry for taking so long to reply -- I was on vacation for the week.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now