Category: Microsoft Office

Microsoft Office Word, Excel and Power Point Basics, Tutorials, Tips and tricks

Check if a cell value contains capital letter in Excel

excel-function-to-check-cell-contains-capital-letter

If you want to check if a cell value (text string) contains at least one uppercase letter in excel, then use below function. =NOT(EXACT(LOWER(A1),A1)) Note: A1 is the cell number Above function returns TRUE if the cell value contains atleast one uppercase letter FALSE if the cell value has all lowercase letters         […]

VBA macro to remove duplicates from each individual column [Excel]

vba-macro-remove-duplicates-each-column

VBA macro to remove duplicates from each individual column in excel sheet. This simple macro,  just single line syntax, treats each column as a separate entity and removes all duplicates from each column and keeps only unique values. Also see VBA macro to delete empty columns VBA macro code to remove duplicates from each column

If you want […]

VBA macro to remove special characters from a string in excel

excel-macro-output-remove-special-characters

Simple VBA macro code to remove special characters from a string in excel. You can remove either all special characters or choose which special characters to remove from the string. This macro retrieves each character from the string and checks whether it belongs to A-Z,a-z,0-9 or a space.If it belongs then it stores them into another […]

How to show developer tab in MS word 2007 ribbon?

Show-Developer-tab-option-MS-word-2007

To show/add developer tab in MS word 2007 ribbon, follow below steps. 1. Click on office button, you will get options like shown in below figure. 2. Click “Word options”  at bottom 3. Click Popular button at top-left 4. On right-side, check “Show Developer tab in the ribbon” option 5. Click OK button Now, you can see Developer […]