| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I limit a cell to 72 characters? How?
Can you limit a cell to a certain amount of characters? If so how?
|
|
#2
|
|||
|
|||
|
For typing in text you can use datavalidationallow text lenght, that will
pop up an error message but it won't stop pasting. If you want to automatically truncate anything more than 72 you would need VBA Regards, Peo Sjoblom "Chris" wrote: Can you limit a cell to a certain amount of characters? If so how? |
|
#3
|
|||
|
|||
|
DataValidation Allow Text length equal to or less than 72
"Chris" wrote in message ... Can you limit a cell to a certain amount of characters? If so how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| #### error if cell has more than 255 characters | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
Linear Mode
