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

[Pliushke]

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?

 

[Kevin B]

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.

 

[Mathew]

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