Similar codes
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
TextPercentageMatch
Matching any part of a string in another , then returns 0 if not match, Or ...
2018Jun26
gsplit usage
How to use gsplit to split large files into smaller parts to allow to read it. ...
Feb7
ANStr2Range
Converts a string of items into range, with custom separator.
Opposite of
2022Nov11
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
ProtectString + UnProtectString
Protects or unprotects a string giving a password Using XorD and similar to ...
2020Jan10
DuplicateFileName
Generates new available file name for a certain file in order to duplicate it, ...
2018Jul7