Re: Data Validation

hi Dave

Thanks for the reply, I don't know how to do what you suggest and am
actually not sure if it would do what I need.

I am putting a string of text in a cell some of which may need to be HTML
coded for formatting and which must not exceed 30 characters, so for example
I could put in - Guinness is good for you - which would be 24 characters and
acceptable but because Guinness is a brand name it would require marking for
italicisation viz - <i>Guinness</i> is good for you - would take it to 31 and
my data validation would deem that unacceptable as it is more than 30. But
the HTML coding has not to be taken into consideration so to all intents and
purposes the latter slogan is still only 24 characters.

I therefore want to keep the data validation to prevent a text string going
above 30 but want to ignore the HTML formatting (e.g. <i> etc) characters.

--
Scottie


"Dave Peterson" wrote:

I don't think so.

Maybe you could use a user defined function that parses the value in the cell
and returns the number you need. Then you can check that result.



Scottie wrote:

Hi

I am using data validation in an Excel work*** 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 <i>text</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

--

Dave Peterson

.

Loading