ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing font from lowercase to uppercase easily (https://www.excelbanter.com/excel-discussion-misc-queries/26653-re-changing-font-lowercase-uppercase-easily.html)

Peo Sjoblom

Changing font from lowercase to uppercase easily
 
You can use a formula and a help column

=UPPER(A1)

or for multiple changes use VBA

http://www.mvps.org/dmcritchie/excel/proper.htm


scroll down halfway until you see the UPPER macro

Regards,

Peo Sjoblom

"formhelp" wrote:

In Word I know that we can change the font of an entire document from
lowercase to uppercase without having to re-type the document...is that
possible in Excel?



All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com