software

Hi all,
I need a function which tells me if a cell contains
an alpha character.
That is if cell contains quot;gquot; then True
if cell contains 7 then False

Regards Mick Barry

There are never enough hours in the day, but always too many days
before Saturday.--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: www.excelforum.com/member.php...oamp;userid=31028
View this thread: www.excelforum.com/showthread...hreadid=509582=ISNUMBER(A1)

tests for a number, but that will also pass 123

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;mickbarryquot; gt; wrote
in message ...
gt;
gt; Hi all,
gt; I need a function which tells me if a cell contains
gt; an alpha character.
gt; That is if cell contains quot;gquot; then True
gt; if cell contains 7 then False
gt;
gt; Regards Mick Barry
gt;
gt; There are never enough hours in the day, but always too many days
gt; before Saturday.
gt;
gt;
gt; --
gt; mickbarry
gt; ------------------------------------------------------------------------
gt; mickbarry's Profile:
www.excelforum.com/member.php...oamp;userid=31028
gt; View this thread: www.excelforum.com/showthread...hreadid=509582
gt;

=ISTEXT(A1)

although you can have 7 in a cell formatted as text and this will
return TRUE--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=509582Hi!

Try this:

=ISERROR(A1*1)

You could use:

=ISTEXT(A1)

However, if cell A1 is formatted as TEXT and contains the entry: 7,
ISTEXT(A1) will return TRUE. Using the ISERROR method accounts for that.

Biff

quot;mickbarryquot; gt; wrote
in message ...
gt;
gt; Hi all,
gt; I need a function which tells me if a cell contains
gt; an alpha character.
gt; That is if cell contains quot;gquot; then True
gt; if cell contains 7 then False
gt;
gt; Regards Mick Barry
gt;
gt; There are never enough hours in the day, but always too many days
gt; before Saturday.
gt;
gt;
gt; --
gt; mickbarry
gt; ------------------------------------------------------------------------
gt; mickbarry's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31028
gt; View this thread: www.excelforum.com/showthread...hreadid=509582
gt;
One way:

If a particular alpha character:

=A1=quot;gquot;

If any alpha character:

=AND(A1gt;=quot;aquot;,A1lt;=quot;zquot;)

or perhaps=AND(A1gt;=quot;aquot;,A1lt;=quot;zquot;,LEN(A1)=1)

to prevent quot;a123quot; from returning TRUEOr, if you just want to make sure the entry isn't numeric:

=NOT(ISNUMBER(A1))
In article gt;,
mickbarry gt;
wrote:

gt; I need a function which tells me if a cell contains
gt; an alpha character.
gt; That is if cell contains quot;gquot; then True
gt; if cell contains 7 then False


Thanks Bob,
The function quot;Codequot; looks at the ASCII list (computer character
set)
The formula =IF(AND(CODE(C1)gt;64,CODE(C1)lt;123),TRUE,FALSE)
does a pretty good job, however there are a few exceptions
eg quot;/,],[,^quot; will also produce a True.

Regards Mick Barry

Anyway, like I was sayin', wabbit is the fruit of the land. You can
barbecue it, boil it, broil it, bake it, saute it. Dey's uh,
wabbit-kabobs, wabbit creole, wabbit gumbo. Pan fried, deep fried,
stir-fried. There's pineapple wabbit, lemon wabbit, coconut wabbit,
pepper wabbit, wabbit soup, wabbit stew, wabbit salad, wabbit and
potatoes, wabbit burger, wabbit sandwich. That- that's about it.--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: www.excelforum.com/member.php...oamp;userid=31028
View this thread: www.excelforum.com/showthread...hreadid=509582
Nice one Mr McGimpsey
I'll go with your suggestion.
It even gives the OK to Scandinavian alpha.

Regards Mick Barry

quot;My world my countryquot; rather than quot;My country my worldquot;--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: www.excelforum.com/member.php...oamp;userid=31028
View this thread: www.excelforum.com/showthread...hreadid=509582