Use cell validation explained at
http://www.datapigtechnologies.com/ExcelMain.htm
http://www.contextures.com/tiptech.html


use formula =LEN(A1)<=4 if you mean 4 characters max
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Manuj" wrote in message ...
i want that not more than 4 string should be enter in a cell.......what
should be done