# 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 [A-Z] (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 non-alphabetic character. Your

expectations

may differ.

--ron

.

**Follow-Ups**:**Re: If A3=alpha numeric,"X", if A3=text,"Y", Blank***From:*Ron Rosenfeld

**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

- 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):