Capitalizing fonts


Posted by Denis Manibal on December 17, 2001 6:12 AM

I have a big spreadsheet and would like to convert all the text to capitalized font, how do I do that?

Thank you

Posted by Mark W. on December 17, 2001 6:26 AM

An easy way would be to download the freeware,
ASAP Utility, at www.asap-utilitily.com and use
its Text | Convert to UPPERcase menu command.



Posted by Chris D on December 17, 2001 7:34 AM

if it's a one-off, you could select all sheets and then manually just

Edit
Replace
"a" with "A"
"b" with "B" etc etc

26 replacements @ 10 seconds each....

Hope this helps
Chris D