I need to restrict data within the cell. Here is the scenarios: Within the cell: AA:BB:CC:DD:WW:ZZ 1) Total character = 17 2)Allowed Numbers or Upper Letters Only 3)On the 3-rd,6-th,9-th,12 and 15-in position must be only ":" character Any help on this?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Restrict data within the Cell (Data Validation)

Thread starter dritan0478
Start date Jul 25, 2017
Tags

cell character data excel restrict

dritan0478

New Member

Jul 25, 2017

I need to restrict data within the cell.
Here is the scenarios:

Within the cell: AA:BB:CC:DD:WW:ZZ

1) Total character = 17
[TABLE="width: 743"]
<colgroup><col><col><col><col span="3"><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]2)Allowed Numbers or Upper Letters Only
3)On the 3-rd,6-th,9-th,12 and 15-in position must be only ":" character

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"][TABLE="width: 743"]
<colgroup><col><col><col><col span="3"><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Any help on this?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]