ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I set a maximum characters in a specific cell (https://www.excelbanter.com/excel-discussion-misc-queries/247656-re-how-do-i-set-maximum-characters-specific-cell.html)

Mike H

how do I set a maximum characters in a specific cell
 
Hi,

Select the cell then

data|Validation
From the dropdown select 'Text Length' and set you min/max values

Mike

"ochie" wrote:

Is there a non-VBA way to set a maximum number of characters in a specific
cell?



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

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