Re: If A3=alpha numeric,"X", if A3=text,"Y", Blank
 From: "Gary" <gaurav_ss@xxxxxxxxxxx>
 Date: Mon, 7 Aug 2006 05:50:24 0600
Alpha Numeric = 1 Alphabet (A to Z) and 3 Numerical Digits.
Text = All text, no numbers
"Ron Rosenfeld" <ronrosenfeld@xxxxxxxxxx> wrote in message
news:5csgd2hfavukui7lgtc0ejigt795vpn807@xxxxxxxxxx
On Mon, 7 Aug 2006 01:04:03 0600, "Gary" <gaurav_ss@xxxxxxxxxxx> wrote:
Ok.....this is what am trying to do.
If A3=alpha numeric,"X", if A3=text,"Y", Blank
any ideas?
Your request is a little vague for me.
What is your definition of alpha numeric?
In other words, is there a particular sequence of letters and numbers, or
is it
any sequence which contains both letters and numbers?
Also, do the letters have to be restricted to the set [AZ] (capital
letters
only) or are there other possibilities?
What is your definition of TEXT?
In Excel, text can include the set of numbers, depending on how they have
been
entered. It can also include any nonalphabetic character. Your
expectations
may differ.
ron
.
 FollowUps:
 Re: If A3=alpha numeric,"X", if A3=text,"Y", Blank
 From: Ron Rosenfeld
 Re: If A3=alpha numeric,"X", if A3=text,"Y", Blank
 References:
 If A3=alpha numeric,"X", if A3=text,"Y", Blank
 From: Gary
 Re: If A3=alpha numeric,"X", if A3=text,"Y", Blank
 From: Ron Rosenfeld
 If A3=alpha numeric,"X", if A3=text,"Y", Blank
 Prev by Date: Re: Fomula Problem
 Next by Date: Re: "if" function
 Previous by thread: Re: If A3=alpha numeric,"X", if A3=text,"Y", Blank
 Next by thread: Re: If A3=alpha numeric,"X", if A3=text,"Y", Blank
 Index(es):
Relevant Pages
