Search results 72

Card image cap
ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Card image cap
ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Card image cap
CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Card image cap
ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Card image cap
NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...

Card image cap
RangeValues

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

Card image cap
PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Card image cap
PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Card image cap
SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Card image cap
ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

Card image cap
Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...