| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capital Letter
another way
=IF(EXACT(LEFT(A1,1),UPPER(LEFT(A1,1))),"yes","no" ) -- Gary "F. Lawrence Kulchar" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capital Letter
Thank you...
Very good, FLKulchar "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... another way =IF(EXACT(LEFT(A1,1),UPPER(LEFT(A1,1))),"yes","no" ) -- Gary "F. Lawrence Kulchar" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capital Letter
HELP ONE MORE TIME PLEASE:
The 2 cells I wish to compare are as follows: Miami and MIAMI or New York and NEW YORK I wish to determine which cells are ALL capitalized (not the first letter as before). Please advise. Thanks, FLKulchar "FLKulchar" wrote in message ... Thank you... Very good, FLKulchar "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... another way =IF(EXACT(LEFT(A1,1),UPPER(LEFT(A1,1))),"yes","no" ) -- Gary "F. Lawrence Kulchar" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capital Letter
=EXACT(A1,UPPER(A1))
will tell you whether the text in A1 is all upper case. FLKulchar wrote: HELP ONE MORE TIME PLEASE: The 2 cells I wish to compare are as follows: Miami and MIAMI or New York and NEW YORK I wish to determine which cells are ALL capitalized (not the first letter as before). Please advise. Thanks, FLKulchar "FLKulchar" wrote in message ... Thank you... Very good, FLKulchar "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... another way =IF(EXACT(LEFT(A1,1),UPPER(LEFT(A1,1))),"yes","no" ) -- Gary "F. Lawrence Kulchar" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capital Letter
Thank you...
FLKulchar "Andrew Taylor" wrote in message ups.com... =EXACT(A1,UPPER(A1)) will tell you whether the text in A1 is all upper case. FLKulchar wrote: HELP ONE MORE TIME PLEASE: The 2 cells I wish to compare are as follows: Miami and MIAMI or New York and NEW YORK I wish to determine which cells are ALL capitalized (not the first letter as before). Please advise. Thanks, FLKulchar "FLKulchar" wrote in message ... Thank you... Very good, FLKulchar "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... another way =IF(EXACT(LEFT(A1,1),UPPER(LEFT(A1,1))),"yes","no" ) -- Gary "F. Lawrence Kulchar" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Capital Letter | Excel Worksheet Functions | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| Turn to capital letter | Excel Discussion (Misc queries) | |||
| How to change the first letter in Capital letter | Excel Programming | |||
Linear Mode
