Limit the Number of Characters in an Excel Cell
Data Validation can stop people typing more than a set number of characters into a cell, or insist on an exact length, such as a 10-digit mobile number or a 6-digit PIN code. WhereData → Data Validation → Text length Exact lengthCustom formula with LEN Works inAll versions Allow up to 5 characters Select the … Read more