Re: how to change case

["Andreas J. Guelzow" <aguelzow pyrshep ca>]

On Fri, 2008-10-17 at 13:16 +0800, bill lam wrote:
> On Thu, 16 Oct 2008, a erickson wrote:
>
> > There are functions for changing case:
> Excuse me, how to use UPPER() and LOWER() functions to edit the
> selected block?

This is really not that simple.

Suppose you want to turn A1:C500 into uppercase:

select D1:F500 from the top left down.
enter the following in the op left cell (keeping th ewhoel region
selected):
=upper(A1:C500)
when you type enter to enter this is in the cell make sure to hold down
the ctrl and shift keys.

D1:F500 should now contain the uppercase version and be selected.

copy

select A1:C500 and paste special "as values"

then you still need to clear D1:F500.

...

it would be nice if there were an easier way.

Andreas


-- 
"Liberty consists less in acting according to
one's own pleasure, than in not being subject 
to the will and pleasure of other people. It 
consists also in our not subjecting the wills 
of other people to our own."  Rousseau

Andreas J. Guelzow
Pyrenean Shepherds