limit no of characters in cell

[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

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

[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

[Chip Pearson]

No, this is not possible.


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


"rocket0612"
<rocket0612.1pyaup_1117634710.9343@excelforum-nospam.com> wrote
in message
news:rocket0612.1pyaup_1117634710.9343@excelforum-nospam.com...
>
> 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
>