Does anyone know how to do the following:
I want specific cells in Excel to display 11 characters at all times, no more no less without requiring the user to input exactly 11 characters every time. I believe this is Data Validation, but I can't get figure out the appropriate combo of rules/formulas.

For example:
User types AKRON in A1
Cell displays AKRON?????? in A1

User types PITT in A2
Cell Displays PITT??????? in A2

I figured out the Formula, but it requires the information to be entered into one Cell and displayed in another
For Example: using the following formula in B2 =LEFT(B1&"???????????",11)
User types AKRON in B1
Cell Displays AKRON?????? in B2

It's almost what I want, but I don't want to have to use 2 cells, I'd rather make this a rule for each cell. Let me know if you can,