Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
limit # of chars in a cell
Hi
My question is: how to limit a number o characters in a cell? I'd like make for example col A to be able to write only 8 chars per cell and only text or only numbers. s. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
limit # of chars in a cell
Try Text length option of DataValidation!
-- Regards! Stefi €˛soonic€¯ ezt Ć*rta: Hi My question is: how to limit a number o characters in a cell? I'd like make for example col A to be able to write only 8 chars per cell and only text or only numbers. s. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Upper and Lower case chars in a Cell | Excel Discussion (Misc queries) | |||
sum first 2 chars if 3rd is something... | Excel Discussion (Misc queries) | |||
Anyone notice excel search within cell limited to first 1024 chars | Excel Discussion (Misc queries) | |||
Copy sheets with more than 255 chars in a cell? | Excel Worksheet Functions | |||
remove blanks from a string of chars within a cell? | Excel Discussion (Misc queries) |