Search results 88

Sorted from new to old.

NumberBeforeString

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

Feb1

RangeValues

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

Jan25

PivotTable_ShowHideItems

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

Jan23

PivotTable_ShowHideBlankItems

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

Jan22

SQL Cross Apply String_Split with XML Path

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

Jan20

ConcatenateStrings_AmongString

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

Jan17

Grandchildren files and count

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

Jan11

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

Jan9

CutString9

Cuts from CutFrom starting from any of items found from ...

Jan7

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

1 2 ...5 6