limit no of characters in cell

  • Thread starter Thread starter rocket0612
  • Start date Start date
R

rocket0612

How can I limit the number of charaters (including spaces) in a cell to
48? Additionally, I'm not sure if this is possible, say it applied to
cell A1, once 48 characters are reached, it will then automatically
drop down to the cell below to A2 and do the same again.

thanks
 
Try validation from the Data menu, and select text length less than 49
Copy the data validation into as many cells downwards as you think yo
nee
 
thanks for the reply. regards my second point, is it possible that it
once you type the 49th character it will automatically drop down to the
next cell?

thanks
 
Back
Top