Iam in requirement of a formula in excel for recognising text and
formula for data validation as below.

Validation required:-

1 - The cell should consist of only 10 characters
2 - The first 5 characters should be only text charecters ( eg:
a,b,c........).
3 - The next 4 characters should be only numeric characters ( eg:
1,2,3.....).
4 - The last 10th character should be a text chracter only.

Is this validation possible in excel...........?

If Yes, How ........?,Please....!


Thanks in Advance

Regards
Thyagaraj