Results 1 to 2 of 2

Thread: Restrict data within the Cell (Data Validation)

  1. #1
    Junior Member
    Join Date
    Jul 2017
    Posts
    1
    Rep Power
    0

    Restrict data within the Cell (Data Validation)

    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.

  2. #2
    Junior Member
    Join Date
    May 2013
    Posts
    23
    Rep Power
    0
    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.

Similar Threads

  1. Replies: 5
    Last Post: 09-16-2016, 01:27 PM
  2. Replies: 14
    Last Post: 10-23-2013, 01:54 PM
  3. Replies: 4
    Last Post: 07-27-2013, 02:04 PM
  4. How To Lock Or Protect Cell Using Data Validation
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-06-2013, 02:27 AM
  5. Custom Data Validation :: Using Formulas
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-04-2013, 06:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •