ORIGAMIST SG Can anyone advise on the following ? I got a column where each cell must have 11 characters (Alpha & numerical). Is there a fomula to pick up which cell have lesser or more than 11 character ?
the_unknown SG for length, use =LEN(A1) where A1 contains your text. To do this for a column, just copy the formula. for your qn, use =IF(LEN(A1) ))
ORIGAMIST SG Thank very much for your help. Thanks to xiaomayi too .. you guys have been a darling and great help ...
