Similar codes
Paragraph2Line + Line2Paragraph
Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...
2018Jun2
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
CellSave and CellRead
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
Rows 2 Cell
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
SwapNumbers
Swap two numbers variables without using third variable A trick worth saving ...
2022Oct17
ConvertMultiLine2 + 6
Convert text blocks (by converting line separators from any separator to any). ...
2018Jul11
ANStr2Range
Converts a string of items into range, with custom separator.
Opposite of
2022Nov11
Recently by developer
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
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Random Codes
FindAncherURL_InHTMLRow
Finds the URL (href tag value) for an anchor inside a table row (tr element) ...
Mar4
ContainerHTMLTag_Index
Returns location of the tag that enclosing the location provided inside HTML ...
Oct22
