MrExcel Publishing
Your One Stop for Excel Tips & Solutions

restricting the number of characters in any cell ?

Posted by denis on October 25, 2001 2:05 PM

Is there any way of only allowing one character in any cell and also once a character has being typed in a cell, the cell to the right becomes active.

any idea's appreciated


Posted by Qroozn on October 25, 2001 3:41 PM


you can put data validation in the cell so that the source is "a,b,c,d,e,f,g,h,I,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z". and a VBA macro will enable it to to jump to the next cell. but i am not the quickest at that.

Posted by Alex James on October 25, 2001 5:40 PM

To restrict to 1 character, go to Data>Validation and in the Allow box select Custom. In the Formula box enter : =LEN(A1)<2<p>To select the cell to the right after an entry is made, go to Tools>Options>Edit>MoveSelectionAfterEnter>Direction>Right.