using the =len(a1) works fine unless the cell is empty/blank;
.. it returns count of 1 for blank cell

The result should be zero, not 1
You probably have an invisible white space which is causing the error
Try usingTRIM: =LEN(TRIM(A1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---