Cell Format - Limiting Number of Characters

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.
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

limiting number of characters in a cell 2
Validate the format of a number 14
Restricting more than x number of characters in a cell.... 1
format of number keeps changing 2
Autocopy the first cell with more than 30 characters to a different sheet? 1
find and replace numeric strings in larger text strings 8
preserving cell formatting inside a CONCATENATEd string 8
How can I delete a space/character from a number of fields? 10

Top