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 _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
