MS EXCEL

• ORIGAMIST

  21 Aug 07, 16:38

  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 ?
  
  
• ndmmxiaomayi

  21 Aug 07, 17:52

  Write a macro.
• the_unknown

  21 Aug 07, 21:25

  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)<11;"less";IF(LEN(A1)=11; "exactly";"more" ))
• ORIGAMIST

  22 Aug 07, 09:18

  Originally posted by the_unknown:

  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)<11;"less";IF(LEN(A1)=11; "exactly";"more" ))

  Thank very much for your help. Thanks to xiaomayi too .. you guys have been a darling and great help ...