Creates list of unique items found in a column, returns string with items ...
2020May6
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Returns list of files found in a folder, list separated with custom separator
2018Apr23
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17