How to let write only some simbols in the cell in Microsoft Excel
 

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?

How to let write only some simbols in the cell in Microsoft Excel
 

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?

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?