View Single Post
  #28   Report Post  
Posted to microsoft.public.excel.programming
Leo Heuser Leo Heuser is offline
external usenet poster
 
Posts: 266
Default Searching for Capital Letters

Hi Bernd


skrev i en meddelelse
oups.com...
Hi Leo,

Interesting. Works even for Greek and Cyrillic alphabet.

But you are misleading the poor user :-) I would take UPPER instead of
PROPER ...


So would I :-)

The Danish name for UPPER() is STORE.BOGSTAVER() and for
PROPER() it's STORT.FORBOGSTAV. Easy to pick the wrong
one, especially in a situation where each one will do, and I didn't
pay attention to PROPER(), when the formula was translated.

I'm certain that the poor user now knows, that UPPER would have been
the PROPER function :-)

Regards
Leo Heuser