Need to allow on 30 letters to be entered into a cell; no numbers or characters...

Good Afternoon!

I've seen a number of posts related to data validation and only allowing 'Letters' to be entered into a particular cell, but I haven't seen what I am looking for... In fact, I've not been able to piece together a solution from multiple related searches.

So without further ado...

I am creating a document that I can share with others which restricts what the user can successfully enter. I can use Excel's standard data validation options for all but 3 columns on my spreadsheet which MUST be letters only (A-Z) and have varying length restrictions 30, 50, 120...

Thanks!

BMH

Unfortunately the Text length on DV in Excel doesn't restrict the characters that may be entered.

The attributes of the cell needs to be:
1. Letters only A-Z (no numbers, punction, or other symbols)
2. UP TO the max value, does not NEED to be 30

Thanks!

BMH