How to set limit in number of character in cells?

**mingali** · 01-13-2010, 07:29 AM

Hi,

In our accounting system, only 25 characters are allowed to key in. and normally we prepare in excel before key into the accounting system. However, we tends to forget about the system limitation and key in more than 25 characters to the cells.

In order to combat this problem, i would like to know is there a way to set limit on the cells for maximum 25 characters only (including space).

Thanks

**DonkeyOte** · 01-13-2010, 07:36 AM

You can perhaps consider using Data Validation: http://www.contextures.com/xlDataVal06.html#Text
(not 100% watertight but may suffice...)

**Richard Buttrey** · 01-13-2010, 07:36 AM

Hi,

One way would be to use the Sheet Change event. e.g.

Please Login or Register  to view this content.

Obviously change the A:A column to reflect your circumstances.

Rgds

**sweep** · 01-13-2010, 07:39 AM

Hi,

Highlight the cells you require limiting,

Data > Validation > Custom > =(LEN(cell)<=25)

where cell is the top left cell in the highlighted range

**scaffdog845** · 01-13-2010, 08:55 AM

Data ribbon - choose Data Validation in the Data Tools section. On the settings tab under Allow, choose text length then set Data to less than and Maximum to 26. The cell will then be limited to 25 characters