July 16, 2010
Hi Dritan,
You could use a custom formula in a data validation list, but my feeling is that it would be way too complicated as there are too many variables that aren't allowed.
You'd be better off splitting the input into it's 6 parts (6 columns) and then concatenating them again it in a 7th column with the colons separating each part. You can use a data validation list for the 6 parts that lists the input options in the correct case.
Mynda
VIP
Trusted Members
June 25, 2016
Hi Dritan
Another suggestion is to allow user to input the data (excluding the colon) into one cell and then concatenating it in another to include the semi colon.
Whenever you need to key any data that have fixed delimiters, I would suggest leaving out the delimiters to make the inputting easier.
See attached.
Hope this helps.
Sunny
VIP
Trusted Members
June 25, 2016
1 Guest(s)