Thyagaraj Wrote:
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

This is by no means a complete answer to your question.

If you go to Data - Validation... then where it says Allow, choose
Custom.

This will check for the length and the middle 4 being numbers: (I'm
assuming this cell is A1)

=IF(AND(LEN(A1)=10, ISNUMBER(MID(A1,6,4))),TRUE,FALSE)

As for checking the remaining characters for their valid values, I'm
not sure what the exact limitations you have on them are. In addition,
I don't really have any ideas on how to check without writing a custom
function to call. Someone else may have to give you ideas on how to
check the other 6 characters. If you figure out a way, just slip it in
the AND(.. , .. , ..).

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=563935