Category: MS Excel

Microsoft excel tips and tutorials

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 open two excel files side by side or in two different windows?

open-two-excel-files-side-by-side

If you want to open two excel files side by side (or) in two different windows to make it easy for file comparison or to find the differences between them, then follow below steps. I saw few people struggling when they want to do something (compare/copy-paste/finding differences) between two excel files. They open two excel […]