Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I am using data validation in an Excel worksheet where I need to limit the character length in particular cells to either 74 or 30 characters. In some instances I am putting HTML coding in the cells as well but it does not need to be counted within the character limitation, i.e. in some cells I can only put 30 characters but if I insert the coding for italics <itext</i in the cell as well it can be ignored. Is there anyway I can get the data validation to ignore particular characters? Any help greatly appreciated, Thanks -- Scottie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |