S
sammy
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
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