Similar codes
Range2Block
Concatenate all rows found in a range starting A1Cell for Columns_To columns ...
2023Mar6
UnUnixDateTime
Convert a number represents a date in Unix format back into date, opposite of ...
Jan6
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
Arr_1Dim_2Str
Converts 1-dimension array into text. Meet Join. A way to convert array into ...
Aug14
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
ConvertMultiLine2 + 6
Convert text blocks (by converting line separators from any separator to any). ...
2018Jul11
CellSave (SimpleSave)
Saves value to cell without deformation and converting Used to be called ...
2018Jun26
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
Random Codes
Highlight row of current month
Highlight row in Excel if it is within current month This is another version ...
2021Sep2
StringFlip
Flips a string, right-to-left, and if passed again, will flip it back Can be ...
2018Jun2