Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to limit the characters in a cell
Hi,
I have to limit the characters in a cell, for Ex: In C2 the characters should only be 8 characters and not more than or lesser than. Even though if i try to use more than 8 characters it should not allow me to do that. Please help me out in this, Regards, Igneshwara reddy. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to limit the characters in a cell
Use data validation with a type of Cuustom and a formula of
=LEN(C2)=8 -- __________________________________ HTH Bob "Igneshwara reddy" wrote in message ... Hi, I have to limit the characters in a cell, for Ex: In C2 the characters should only be 8 characters and not more than or lesser than. Even though if i try to use more than 8 characters it should not allow me to do that. Please help me out in this, Regards, Igneshwara reddy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to limit cell to 30 characters or less | Excel Discussion (Misc queries) | |||
How do I limit characters in a cell? | Excel Worksheet Functions | |||
Can I limit a cell to 2 characters? | Excel Discussion (Misc queries) | |||
limit no of characters in cell | Excel Discussion (Misc queries) | |||
Can I limit a cell to 72 characters? How? | Excel Discussion (Misc queries) |