Single line of text column validation to take ONLY Alphabets

Question

_{Monday, July 14, 2014 6:49 AM}

Hi,

May some experts please suggest a Formula that I can use to validate a column of type "Single line of text" to intake ONLY alphabets ? (i.e. it should not take numerical).

The field is "Candidate's Name" and hence field should not intake numerical!

Naveed.DG MCITP, MCTS -SharePoint 2010 Administrator "Vote As Helpful" If it helps!!

All replies (5)

_{Tuesday, July 15, 2014 7:43 AM ✅Answered | 1 vote}

Hi Naveed,

kindly use below formula for "Single Line of text" Validation:

Edit "Candidate's Name" column and click column validation.

paste below code in formula window and set custom message as your convenient.

=AND(IF(ISERROR(FIND("0",Title)),TRUE),IF(ISERROR(FIND("1",Title)),TRUE),IF(ISERROR(FIND("2",Title)),TRUE),IF(ISERROR(FIND("3",Title)),TRUE),IF(ISERROR(FIND("4",Title)),TRUE),IF(ISERROR(FIND("5",Title)),TRUE),IF(ISERROR(FIND("6",Title)),TRUE),IF(ISERROR(FIND("7",Title)),TRUE),IF(ISERROR(FIND("8",Title)),TRUE),IF(ISERROR(FIND("9",Title)),TRUE)

Thanks

Rajiv Kumar

Please remember to click 'Mark as Answer' on the answer if it helps you

Rajiv Kumar

_{Monday, July 14, 2014 6:57 AM}

Hi,

Try ISNUMBER Formula and look for false value. please refer the link

http://office.microsoft.com/en-in/windows-sharepoint-services-help/is-functions-HA001161040.aspx

http://sharepoint.stackexchange.com/questions/30817/validate-if-the-entered-text-is-number

Please remember to click 'Mark as Answer' on the answer if it helps you

_{Tuesday, July 15, 2014 8:55 AM}

Thank you so much Kumar, your formula works like a Charm...Thanks....

Naveed.DG MCITP, MCTS -SharePoint 2010 Administrator "Vote As Helpful" If it helps!!

_{Wednesday, November 2, 2016 12:11 AM}

Searching for 0-9 does not check for special characters.

What is the formula that will explicitly check for letters?

_{Wednesday, November 2, 2016 12:19 AM}

Posted too soon.

In my requirement, I'm only checking the first character.  So, I'm using LEFT([Title],1) to look at the first character and confirm it is a letter.

=AND(LEFT([Title],1)>="a",LEFT([Title],1)<="z")

This will ensure the first character is a letter.  

Figure the ol' "between a and z" trick could be applied to the entire string... but, I'm going to stop here.