Thread: Capital Letter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default Capital Letter

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