return value based on number of characters in cell / field
Use the LEN function. Look it up in Excel help.
--
David Biddulph
"Perplexed" wrote in message
...
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
|