Wxcel question

[Manuj]

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

[David McRitchie]

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" <Manuj@discussions.microsoft.com> wrote in message news:6FF657DD-5705-439E-9902-93165300A8B3@microsoft.com...
> i want that not more than 4 string should be enter in a cell.......what
> should be done