[Office] Transfer Capital Letters in Excel

This could be done through a few code steps. Please follow the instruction below:

Save your Excel File as “Excel Marco-Enabled Workbook (*.xlsm)

·         Add one column to help you to identify which filed has Capital character visibly

·         Type the formula in to the filed (Change your target field, in the case is A2), then apply to the whole column

IF it returns “FALSE”, it means you have UPPER case in the field

                =EXACT(A2,LOWER(A2))

[Office]Excel - Two Windows are opeing One blank the other a file

Solution:

Win7:

• go to

         C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART

• delete

         *.xsb