search for words with capital letter at end

[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

 

[FSt1]

hi
excel usually doesn't distinguish between upper and lower case so you have
to be specific about the character.
=if(right(D18,1) = CHAR(77), "Yes","no")

in ASCII, the uppercase M is character 77, the lower case m is character 109.
for future reference....
=char(77) and =char(109)
to see all...
in A1 enter =char(row())
copy down to row 256.
some of the characters are "non-printable" characters like space, tab,
backspace so you will only se a small square. some are hold overs from old
teletype days(the origin of ASCII) like begin text, end text, end
transmittion, devise control 2(whatever that is).

regards
FSt1

 

[FSt1]

hi
if you what to "see" the non-printable characters...
http://www.asciitable.com/

regards
FSt1

 

[Roger on Excel]

Thanks for the help,

Best regards,

Roger

hi
if you what to "see" the non-printable characters...
http://www.asciitable.com/

regards
FSt1

 

[T. Valko]

Try this:

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

 

[Manic]

You can use the "FIND" function which differentiates between upper and
lowercase (similar to SEARCH" function)

 

[Excel_Learner]

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

You can use the "FIND" function which differentiates between upper and
lowercase (similar to SEARCH" function)

 

[T. Valko]

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

A few keystrokes shorter:

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