Limit the input in a cell to a single character

[elevinson]

I am using an Excel spreadsheet as an input form for keying. Is there a way
to limit the input to a single character per unlocked cell and then have the
cursor move to the next unlocked cell?

 

[Jim Thomlinson]

No there is no way to get XL to limit the inputs to a single character.
Macro's don't run wheil you are in edit mode and there is nothing built in
that performs that function... Best option is probably to use Tab/Enter to
move the cell.

 

[Andy Pope]

Hi,

You can limit the input but it will only check the length when you try
and move to the next cell.

See Debra's page on data validation, specifically the Text Length example.
http://www.contextures.com/xlDataVal06.html

Cheers
Andy

 

[SteveM]

You can limit entry to a single character using Data Validation. Use
Text Length validation setting the length = 1 to accept any single
character. Or create a list of the single characters that you want to
accept as inputs and validate to the list.

SteveM