--
>
>*From:* Paul Schreiner
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Monday, March 2, 2015 9:31 AM
>
> *Subject:* Re: $$Excel-Macros$$ Function for Data validataion
>
> OOps... sorry.
> ISTEXT
D(B8,1,1)),
>>ISTEXT(MID(B8,2,1)),
>>ISTEXT(MID(B8,3,1)),
>>ISTEXT(MID(B8,4,1)))
>>
>>Paul
>>
>>
>>
>>-------------
>>“Do all the good you can,
>>By all the means you can,
>>In all the ways you can,
>>In all the places you can,
>>
all the places you can,
>At all the times you can,
>To all the people you can,
>As long as ever you can.” - John Wesley
>-
>
>
> From: Ashish Bhalara
>>To: excel-macros@googlegroups.com
>>Sent: Saturday, February 28, 2015 5:15
, 2015 5:15 AM
>Subject: Re: $$Excel-Macros$$ Function for Data validataion
>
>
>
>Hi Mr.Paul
>I make below condition to check first four character is Alphabetic.
>
>
>=AND(LEN(B8)=11,ISNUMBER(INT(RIGHT(B8,7))),CODE(LEFT(B8,1))>64,CODE(LEFT(B8,1))<91,CODE(MID(B8,2,
Hi Mr.Paul
I make below condition to check first four character is Alphabetic.
=AND(LEN(B8)=11,ISNUMBER(INT(RIGHT(B8,7))),CODE(LEFT(B8,1))>64,CODE(LEFT(B8,1))<91,CODE(MID(B8,2,1))>64,CODE(MID(B8,2,1))<91,CODE(MID(B8,3,1))>64,CODE(MID(B8,3,1))<91,CODE(MID(B8,4,1))>64,CODE(MID(B8,4,1))<91)
Could yo
Dear Mr.Paul, Thanks to reply.
But problem of third criteria is still not fulfill as per your condition of
'ISTEXT(MID(A1,1,1)'
The output is same 'TRUE' whether entered value is alpha or numeric.
Please give me a solution for it or macro also preferred if possible.
Regards.
Ashish Bhalara
9624111
If the cell you're validating is A1, with the current value of:
abcd1234567
-
Your first criteria is easy:
Len(A1)=11
-
The second criteria: "last 7 characters are numeric"
CAN be fairly simple, depending on your definition of "numeric
