Can you provide a little more detail? For example, how are the IDs delimited
(line feeds, commas, tabs, something else)? When you say "validation", do
you mean after an entry is completed via a formula, Data Validation, via a
macro, something else? How do you want to be notified of any IDs exceeding
150 characters? I'm not sure if everything I asked you about is doable, but
it would definitely help if you told us what you are expecting to do.

Rick


We have a excel sheet in which in one of the cell we are storing multiple
Email id's .
Now we want to have lenght validation on each Email id such that each
email
id's text lenght must not exceed 150 character lenght.We can apply
validation
to text of cell, but how we can apply individual validation to each email
id.