I want to use a cell for the input of a search field. However, I want the cell to contain a predefined text namely: +++____/____/______+++ the first section contains 3 digits, the second contains 4 digits, and the third section contains 5 digits. If one clicks in the cell, the user must enter 12 digits in the total: 3, 4 and 5. So 12 in the total that the user enters consecutively. The end result should look like this: +++123/1234/12345+++ I've tried via data validation (via a formula) but I can't find a formula that allows for a predefined text. Thanks for the help.
Predefined text in a cell
-
-
Hi,
Sadly the input mask feature offered by Access in not offered by Excel ....
But, there is an unlimited flexibility with a UserForm Textbox to monitor Only Numbers inputs for your 12 Digit Validation rule, and obviously plus Concatenation and Formatting combined ... to produce your expected result
-
Hi again,
For the sake of illustration, attached is a test file
-
Hi,
Thanks for this illustration.
It helps a lot
-
You are welcome
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!
