View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
plunk25 plunk25 is offline
external usenet poster
 
Posts: 9
Default Limit number of chacters in cell

I have an an excel sheet that has a list of 18,000 items. I need to import
them into a system that can only handle 30 characters per cell. I have
several cells that are easily over 40 characters.

Does anyone know how I can cut off the last characters? Say that it had 40
characters, I need to strip off the last 10.

Thanks!