Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » Finding Stray Text

Finding Stray Text

I have a range that should only contain numbers. Blanks are OK, but I need to determine if anyone "deleted" a cell by typing a space or entered text in any other way. This worksheet formula returns TRUE if there is text in the range: =COUNTA(A1:C6)-COUNT(A1:C6)>0 COUNTA counts all the non-blank cells while COUNT counts [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2009/01/27/finding-stray-text/

Posted Jan 27 2009, 09:36 AM by Daily Dose of Excel
Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.