Thread: Capital Letter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Capital Letter

One possibility:
=ISNUMBER(FIND(UPPER(LEFT(A1)),LEFT(A1)))

or
=CODE(LEFT(A1))<97

assuming all of your data starts w/a letter, not some other character or
number.

If you need to force the first letter of each word in your strings to
uppercase, check into the PROPER function.

"F. Lawrence Kulchar" wrote:

I have a bunch of cells, say A1 thru A50,

each of which is occupied by a text string, such as...

New York or
chicago or
abc or
Abc

etc, etc,etc.

HOW CAN I TEST EACH CELL FOR...WHETHER OR NOT THE STRING BEGINS WITH A
CAPITAL LETTER?????

In other words, chicago will yield..."no"

and, Chicago will yield..."yes".

Please advise,

FLKulchar