+ Reply to Thread
Results 1 to 3 of 3

Data Validation for 5 digit alpha entry only

Hybrid View

wotadude Data Validation for 5 digit... 12-03-2008, 09:49 PM
Teethless mama =and(len(a1)=5,sumproduct(len(... 12-04-2008, 12:26 AM
wotadude Thanks Teethless mamma done... 12-04-2008, 03:34 PM
  1. 12-03-2008, 09:49 PM #1
    wotadude is offline
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    Data Validation for 5 digit alpha entry only

    I require a formula for custom data validation to permit entry 5 digit aplha characters only.
    No spaces, or numbers permitted.
    thanks.
    Last edited by wotadude; 12-04-2008 at 03:34 PM.
    Reply With QuoteRegister To Reply
  2. 12-04-2008, 12:26 AM #2
    Teethless mama is offline
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211
    Quote Originally Posted by wotadude View Post
    i require a formula for custom data validation to permit entry 5 digit aplha characters only.
    No spaces, or numbers permitted.
    Thanks.
    =and(len(a1)=5,sumproduct(len(a1)-len(substitute(substitute(a1,char(row(indirect("97:122"))),""),char(row(indirect("65:90"))),"")))=5)
    Reply With QuoteRegister To Reply
  3. 12-04-2008, 03:34 PM #3
    wotadude is offline
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255
    Thanks Teethless mamma done the job nicely.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1