| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to write X Bar in Microsoft Excel Sheet? | New Users to Excel | |||
| how i can write arabic numbers by microsoft excel word | Excel Discussion (Misc queries) | |||
| Is there a write-multi-cell-at-once function in VBS for Excel? | Excel Discussion (Misc queries) | |||
| Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
| write value to another cell in excel | Excel Worksheet Functions | |||
Linear Mode
