search for capital letter at end of text string

[Roger on Excel]

I need to search for a word with a capital letter at the end of the string.

For example

Hydrochloric acid 1M

Ive tried using =IF(RIGHT(D18)="M","yes","no"), but it doesnt differentiate
between lower case and upper case.

Can anyone help?

Thanks,

Roger

 

[Rick Rothstein \(MVP - VB\)]

Try it this way in order to check for a specific upper cased letter...

=IF(EXACT(RIGHT(D18),"M"),"yes","no")

and this way to see if the letter, no matter which one it is, is upper
case...

=IF(AND(CODE(RIGHT(D18))>=65,CODE(RIGHT(D18))<=91),"yes","no")

Rick

 

[Dave Peterson]

If the last character is always a letter:
=IF(EXACT(UPPER(RIGHT(D18,1)),RIGHT(D18,1)),"Upper","NotUpper")

But this will return Upper for numbers, punctionation, special characters, ...

=IF(AND(CODE(RIGHT(D18,1))>=CODE("A"),CODE(RIGHT(D18,1))<=CODE("Z")),
"upper","not upper")

Checks for A to Z.

 

[Dave Peterson]

Check your other post.

I need to search for a word with a capital letter at the end of the string.

For example

Hydrochloric acid 1M

Ive tried using =IF(RIGHT(D18)="M","yes","no"), but it doesnt differentiate
between lower case and upper case.

Can anyone help?

Thanks,

Roger

 

[Roger on Excel]

Thanks - that is exactly what i was looking for

regards,

Roger

 

[Roger on Excel]

Thanks for the help,

Best regards,

Roger

If the last character is always a letter:
=IF(EXACT(UPPER(RIGHT(D18,1)),RIGHT(D18,1)),"Upper","NotUpper")

But this will return Upper for numbers, punctionation, special characters, ...

=IF(AND(CODE(RIGHT(D18,1))>=CODE("A"),CODE(RIGHT(D18,1))<=CODE("Z")),
"upper","not upper")

Checks for A to Z.