Wxcel question

[Guest]

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