Hi

You are very close...

With both cells selected use this validation formula:

=LEN($E$13)+LEN($F$13)<=9

Notice the formula shall always start with an equal sign, and I used
absolute references.

Hopes this helps.
....
Per

"sammy" skrev i meddelelsen
...
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