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

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

Hi SunnyKow,

You have provide a very smart way.

But please read my attached file, because still i cannot find a solution.

Best Regards,

Dritan

Hi Dritan

Under the Find And Replace - Find tab, change the Look in option to Values instead of Formulas.

You should be able to find them now.

Sunny

Hi SunnyKnow,

Yes you are right, I selected the Value in Look in, and I find it.

Thank you for your support 🙂

Sunny is always helpful...