G Guest Apr 20, 2006 #1 i want that not more than 4 string should be enter in a cell.......what should be done
D David McRitchie Apr 20, 2006 #2 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
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
