View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Searching for Capital Letters

Hi Bernard

I agree absolutely, but nonetheless I will take the time to investigate
the use of MMULT for other occasions.
Thank you for drawing it to my attention.

--
Regards

Roger Govier


wrote in message
ups.com...
Hi Roger,

Please forget my MMULT approach. Tom's SMALL combined with Nick's
LCASE
or LOWER was it.

MMULT was part of a complicated way to construct {0,0,1,0,2,0,0,3,..}
to get the order of capitals.

But maybe there will be a more elegant use for these matrices
{1,1;0,1}
or {1,1,1;0,1,1;0,0,1} in future :-)

Nick's way of comparing UPPER and LOWER will save the day for
Scandinavians, Germans, etc.

Regards,
Bernd