=IF(ISERROR(FIND("R",RIGHT(E6,1),1)),"no","yes")

A few keystrokes shorter:

=IF(COUNT(FIND("R",RIGHT(E6))),"yes","no")


--
Biff
Microsoft Excel MVP


"Excel_Learner" wrote in message
...
=IF(ISERROR(FIND("R",RIGHT(E6,1),1)),"no","yes")

"Manic" wrote:

You can use the "FIND" function which differentiates between upper and
lowercase (similar to SEARCH" function)
On Jul 22, 7:26 am, Roger on Excel
wrote:
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