Results 1 to 4 of 4

Thread: Data Validaton

  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is it possible to restrict cell input to numbers, spaces and letters?

    NO dashes,periods,commas,backslashes etc. such as

    ab123 3

    zx 456 ad

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Do you want to do this for specific cells only, or for all cells in a worksheet (or even workbook)?

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    One entire column

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I suspect that somebody will come up with a really clever solution, but I don't know of a satisfactory one. If I really needed to do this, I'd use Access instead of Excel.

Posting Permissions

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