Blog Marco

I was messing around deleting first or last words in Excel. But now I want to edit those words so they are either all upper case, all lower case or in "proper format" (first letter upper case, subsequent letters lower case). So the plan is to find a formula or a macro to do this all automagically so I wouldn't need to go into each individual cell editing each one. Here is the code you are after:

THIS IS THE FORMULA MACRO CODE IF YOU WANT TO CHANGE ALL THE LETTERS OF YOUR EXCEL CELL INTO UPPERCASE LETTERS:

=UPPER(Cell)

this is the formula macro code if you want to change all the letters of your excel cell into lowercase letters:

=LOWER(Cell)

This Is The Formula Macro Code If You Want To Change All The Letters Of Your Excel Cell Into Uppercase Letters:

=PROPER(Cell)