Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7
Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...
2018Jul7
Imports multiple CSVs found in a folder into worksheets of active workbook ...
2023Mar20
Imports rows from multiple sheets of a workbook into final sheet along with ...
2020Nov11
How to use gsplit to split large files into smaller parts to allow to read it. ...
Feb7
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
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
Switch text inside cells with another text. This was needed to correct an bug ...
Feb23
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...
2020Feb19
Encodes and decodes a string, Base64 is used to convert binary data (like ...
2018Jul31