View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
greatdeals_007 greatdeals_007 is offline
external usenet poster
 
Posts: 1
Default Urgent help needed? How do I limit the number of characters in a

I am using a program that limits the number of characters in a product model
number to 12 characters. my file currently contains may line items with
model numbers that exceed this limit.

how do I format the column to shorten the number of characters? I have
tried using the data validation but it did nothing for me. can you help?