Data Validation
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
|