Thread: Searching for Capital Letters
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.programming
Bernd Plumhoff[_4_] Bernd Plumhoff[_4_] is offline
external usenet poster
  
Posts: 4
Default Searching for Capital Letters
Hello,

Or
=SMALL(IF(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))), 1))<CODE(MID(LOWER(A1),ROW(INDIRECT("1:"&LEN(A1)) ),1)),ROW(INDIRECT("1:"&LEN(A1)))),B1)
array-entered. Put 5 into cell B1.

Regards,
Bernd
Reply With QuoteReply With Quote