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.
Don’t have an account yet? Register yourself now and be a part of our community!