Number of character in one cell.

A

Aom

How should I set if there is dialog showed that:

The text string you entered is too long. Reduce the number of characters
used or cancel the entry.

and I can't click anything for adjustment?
 
P

Peo Sjoblom

Look under data>validation, allow>text length, then select error message

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Top