ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   setting a cell length limit (https://www.excelbanter.com/excel-discussion-misc-queries/210703-setting-cell-length-limit.html)

jxbeeman

setting a cell length limit
 
Hi,
I'm looking to set the number of characters in a given columns cells to a
certain number. For example, column B i want a maximum of 68 characters in
each cell with a min of 0. Any ideas would be appreciated.

Thanks, Josh


Bernard Liengme

setting a cell length limit
 
Have you looked at Data Validation? There is a Text Length setting.
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jxbeeman" wrote in message
...
Hi,
I'm looking to set the number of characters in a given columns cells to a
certain number. For example, column B i want a maximum of 68 characters
in
each cell with a min of 0. Any ideas would be appreciated.

Thanks, Josh





All times are GMT +1. The time now is 03:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com