View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paula Paula is offline
external usenet poster
 
Posts: 138
Default LEN and Numeric Formula

Hi,

I am trying to identify in a cell if the entry is 6 characters long and the
characters are all numbers, the answer is yes, otherwise no. can you advise
if this is possible?

Many thanks

Paula