View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mathew mathew is offline
external usenet poster
 
Posts: 75
Default How to let write only some simbols in the cell in Microsoft Ex

Go to: DATA then VALIDATION click the Allow box and select text length.
Click on the Maximum and type in 50!

Go to TOOLS DATA Valadation

"Kevin B" wrote:

You can limit the number of characters in a cell without any coding by using
Data Validation to set the maximum number of characters allowed.
--
Kevin Backmann


"Pliushke" wrote:

I need to do that thing in Microsoft excel : I need some funcion that lets to
write only 50 simbols and not more in the cell. Maybe somebody can help me
and write a functio wich can do it?