Thread: search for words with capital letter at end
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger on Excel Roger on Excel is offline
external usenet poster
  
Posts: 249
Default search for words with capital letter at end
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
Reply With QuoteReply With Quote