Cell Format - Limiting Number of Characters

  • Thread starter Thread starter ANDREW MC
  • Start date Start date
A

ANDREW MC

Would it be possible to limit the number and format of the characters
entered into a cell? For example
XXX 12345 /XX. As you typed the X's and numbers would be replaced and the
"?' preserved. Maintaining the spacing is what is most important.
 
Excel doesn't have an input mask feature similar to the one in Access.

You could use three cells for data entry, and use data validation to
control the data in each. Then, use a formula in another cell, to
combine the data and the necessary spacing.
 
Back
Top