View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sammy sammy is offline
external usenet poster
 
Posts: 48
Default Total Text Length of Adjacent Cells

Hi All,

I have two adjacent cells (E13 and F13) and i want to restrict the length of
the text so that their ~combined~ length is less than 9 characters. I tried
to use data validation with "custom" and the formula like:
Len(E13)+Len(F13)<=9
but as most of you know, this didn't work.
Any help is appreciated.
TIA