On Tue, 7 Mar 2006 08:52:54 -0800, Jim May
wrote:

In cells A1:A3 I have:
(as text)

Cell Values Formula Needed
0100 01029250 FALSE
0100 01029304 FALSE
0100 REHAB01 TRUE

I need a formula in Cells B1:B3
to Recognize is a cells has characters A-Z

I can't quite figure out here, under pressure...

Can someone assist?

1. Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr

2. Use this formula:

=REGEX.COMP(A1,"[A-Z]")


--ron