View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wayne Wayne is offline
external usenet poster
 
Posts: 133
Default Limiting a Column to "X" Number of Characters

I can't find a way to edit my original question, so I'm restating it here.
Marcelo gave me a great response, but what I want is to limit it to 33
characters even if there are 100 characters in the response. What happens
with the Data--Validation is that if you enter a response over 33, if rejects
the response. I want it to take the first 33 characters and enter that
information and ignore the rest. I hope this makes sense.

Thanks,

Wayne