Similar codes

Card image cap
Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2

Card image cap
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

Card image cap
CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

Card image cap
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

May23

Card image cap
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

Card image cap
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

Card image cap
SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

Card image cap
ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

Card image cap
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

Recently by developer

Card image cap
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

Thu 3PM

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

Random Codes

Card image cap
ProtectString + UnProtectString

Protects or unprotects a string giving a password Using XorD and similar to ...

2020Jan10

Card image cap
Collapse Menu

A Bootstrap 4 collapse menu, easy to adapt A pen from

2019Aug7

Card image cap
sortArray

Sort an array of Numeric values, simple straightforward Edit v3 2021-09-21: ...

2018Jul25

Card image cap
ServerUptime

Return how long the computer has been running. Return format is dd:hh:mm:ss ...

2018Jul11