View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default cut-off text in cell.. I want excel to cut-off the text after # of char.

Hello;

I have an excel document that I am using a a tab-delimited file for
InData. InData will allow me to populate an Adobe InDesign document,
using exel. (or another tab-del. file).

What I want to do, is force Excel to cut-off the data in the cell after
a certain # of characters. Not a whole lot either, the # would be
close to 30.

Does anybody have an idea if and how Excel would accomplish this?

THANK YOU!