Try This

In a custom validation formula

=AND(ISERROR(FIND(" ",C1,1)),AND(LEN(C1)0,LEN(C1)<=15))

"C1" is a example cell


Regards Fernando Ortiz


"Ron de Bruin" escribió en el mensaje
...
You don't have to use a macro
Check out Datavalidation in the menubar

See text length

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"efi" wrote in message
...
Hi,
How can I insert in my code function that set for a specific column the
validation condition of string 1-15 chars without blanks?

thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/