Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scottie Scottie is offline
external usenet poster
 
Posts: 16
Default 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