How to restrict some data within the Cell
AA:BB:CC:DD:WW:ZZ
Total character = 17
Allowed Numbers or Upper Letters Only
On the 3-rd,6-th,9-th,12 and 15-in position must be only ":" character.
Printable View
How to restrict some data within the Cell
AA:BB:CC:DD:WW:ZZ
Total character = 17
Allowed Numbers or Upper Letters Only
On the 3-rd,6-th,9-th,12 and 15-in position must be only ":" character.
Welcome to the forum!
That looks like an 18 IF()s formula. The easier route would be to use a macro as a worksheet change event to do the check.