Python script to extract string between two delimiters

Simple python script to extract sub string between two delimiters of a string. Examples of delimiters are brackets, parentheses, braces, single or double quotes etc. You can also customize this code to extract the string between two special characters or two sub strings. Comments on each line of code explains you to easily understand the code. Note: […]

VBA macro to find duplicates in excel

macro-duplicates-highlighted-in-red

VBA macro to find duplicates in excel sheet. This macro finds the duplicates in user selected range and highlights them in light red color. VBA code to find and highlight duplicates

Add above code to your excel workbook How to use this macro Select the range (column/row/columns and rows…) in which you want to […]

Macro to extract file name from file path [Excel VBA]

Excel VBA macro to extract file name from file path. This macro extracts the string (file name) which is between dot (.) and backslash(\) delimiters (from right side).

VBA macro to remove duplicates from each 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. VBA macro code to remove duplicates from each column

If you want to remove duplicates from a single column, […]

Page 1 of 912345...Last »