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
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
SettingRead_JSON
Reads certain value for a certain setting from FullJSONString text block. See ...
Jan8
ANmAdvancedFilter
Filter table inside Excel the fast way (using advanced filter) into another ...
2022Sep15
ListBox_Excel_Sort
Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...
2020Sep21
OnChange
Detect when user changes a textbox using JQuery Needed to have this documented ...
2018Dec29