Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30
Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...
2018Jun14
Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...
2018Jun2
Convert HTML text into DB-safe string, by converting some characters as below. ...
2019Feb7
Switch text inside cells with another text. This was needed to correct an bug ...
Feb23
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
Imports multiple CSVs found in a folder into worksheets of active workbook ...
2023Mar20
This is to demonstrate how to call a Fancybox from inside an iframe into parent ...
2019Jan15
Reads everything in a column (starting from certain cell until blank cell is ...
2018Jun10