Formatting a spreadsheet

G

Gwyn42

Is there any way to format cells in a spreadsheet so that everything i
in capital letters?

Thanks for any help
 
M

Mark Graesser

But if you really must

=UPPER(A1

You could use this in a side area on your sheet, or another sheet, and then Edit>Copy and Edit>Paste_Special>Values over the original data

Good Luck
Mark Graesse
[email protected]

----- Don Guillett wrote: ----

Please don't do that to your sheet viewers
 
Top