limit no of characters in cell
 

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


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=375572

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 you
need


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=375572

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


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=375572

No, this is not possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"rocket0612"
wrote
in message
...

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


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile:
http://www.excelforum.com/member.php...o&userid=19492
View this thread:
http://www.excelforum.com/showthread...hreadid=375572