limit no of characters in cell

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
 
G

Gary Brown

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
 
R

rocket0612

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Formats - Limit # of characters 3
limit number of characters in cell 4
limit # of chars in a cell 1
Add a limit of 140 characters to any cell 1
How to limit the number of characters in a cell? 5
Count Characters with space in a cell 5
# of Characters/cell 2
Change font in portions of cell with many characters (1000's) 6

Top