thanks Ardus
but the condition is such that
i must validate through...
Data------validation---------
and i am using
"if validation=true" in vba code to check each cells value


--
hemu


"Ardus Petus" wrote:

Try:
=LEN(A1)+LEN(B1)+LEN(C1)0

HTH
--
AP

"Hemant_india" a écrit dans le
message de news: ...
hi
i have thre columns of which at least one should contain some text
how do i validate such condition?
thanks

--
hemu