m] On
Behalf Of Sam Mathai Chacko
Sent: Feb/Mon/2012 07:22
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ $$Excel-Macros$$ Validate text and number in PAN
Ah! Quote Haseeb {I think this part ISNUMBER(--MID(A3,6,4)) will allow entry
with 3 spaces before the fourth digit :-) , lik
Ah! Quote Haseeb {I think this part ISNUMBER(--MID(A3,6,4)) will allow
entry with 3 spaces before the fourth digit :-) , like}
I think that's a very good catch Haseeb. :)
I think adding an IFERROR(FIND(" ",Range)) will solve the problem.
Regards,
Sam Mathai Chacko
On Mon, Feb 27, 2012 at 12
Thanks Sam, Maries & Haseeb.
All three solutions are working fine.thanks again.
Regards,
Vijayendra
2012/2/27 Haseeb Avarakkan
> Hi Sam,
>
> I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces
> before the fourth digit :-) , like
>
> ABCDE 1D
>
> Hi Vijayendra,
>
> T
Hi Sam,
I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces
before the fourth digit :-) , like
ABCDE 1D
Hi Vijayendra,
This is my try. Firstly define 3 names to avoid INDIRECT function.
Name: *Alpha*
On refers to:
={"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"
I believe the OP was asking for a data validation
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 8:54 PM, Maries wrote:
> Hi,
>
> Please find the attachment.
>
> Regards,
>
> MARIES.
>
>
> On Sat, Feb 25, 2012 at 5:59 PM, Vijayendra Rao
> wrote:
>
>> Dear All,
>>
>> I want to validate text
Hi,
Please find the attachment.
Regards,
MARIES.
On Sat, Feb 25, 2012 at 5:59 PM, Vijayendra Rao wrote:
> Dear All,
>
> I want to validate text and numbers in PAN number. Validation required as
> per below conditions.
>
>
> · Length should be 10
>
> · First 5 character should b
