How do I make a cell allow only 24 alpha/num. char.to be entered

's Computer Specifications

I have a field that will only take 24 alpha/num. char.. How can I limit data
entered into a cell to 24 char. without having to count char.

's Computer Specifications

Fred,

Select the cell, choose DAta / Validation... Under "allow" choose "Text lenght" and the "equal
to" and 24....

HTH,
Bernie
MS Excel MVP

"Fred@JFK" <Fred@(E-Mail Removed)> wrote in message
news:8C97E497-B993-4B4B-849F-(E-Mail Removed)...
>I have a field that will only take 24 alpha/num. char.. How can I limit data
> entered into a cell to 24 char. without having to count char.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to delete numeric characters in a cell with alpha numeric char	Zak	Microsoft Excel Programming	1	5th May 2010 04:06 PM
formula with alpha char in cell	soni	Microsoft Excel Misc	7	9th Jan 2009 04:04 PM
Get "####" when use alpha char in a cell referenced by a formula	Leo	Microsoft Excel Worksheet Functions	5	8th Jan 2009 06:18 PM
WHY: Jump to other cell when First char entered is upper case (2007)	Poul Nielsen	Microsoft Excel Setup	0	22nd Mar 2008 01:16 PM
Re: How do I make a macro remove last char only in a cell?	Martin Richecoeur	Microsoft Excel Misc	0	27th Oct 2003 09:07 PM