Home » Blogs » Almir's blog

Excel macro to change selected range UPPERCASE, lowercase or Proper Case - without additional column and functions

Almir's picture
Submitted by Almir on 20 June, 2013 - 08:22

This macro changes case of selected range. No additional column or UPPER/LOWER/PROPER function necessary.
When you select a range of cells or single cell, run macro and - when prompted - enter "L", "U" or "P" (lower, upper, proper).
Selected cells contents is changed accordingly.

AttachmentSize
Change_Case.txt1.77 KB
»

Great work

Submitted by kannan0408 on 7 January, 2014 - 07:12.

Hi Almir,

Great work, i love it

»
Almir's picture

Thanks

Submitted by Almir on 30 January, 2014 - 23:14.

Thanks

»