Need to Resrtict Characters in a cell

test

Board Regular
Joined
Apr 17, 2002
Messages
182
Hi

I want to create a Excell cell in which i can only input max 55 characters ..

How do i do this??

thanks
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Click on the cell
From the menu on top, Click on Data, then Validation
Under Allow, change it to Text Length
Under Data, change it to less than or equal to
Under Maximum, type 55
Click OK
 

Watch MrExcel Video

Forum statistics

Threads
1,114,059
Messages
5,545,758
Members
410,704
Latest member
Cobber2008
Top