View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Perplexed Perplexed is offline
external usenet poster
 
Posts: 14
Default return value based on number of characters in cell / field

I have a field with varying number of characters, I need function that
returns a value based on the number of characters in field.

ie if field x <2 characters = 1 2 characters = 2

Thanks