Search results 100

Sorted from new to old.

ConcatenateStrings_AmongString

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

2024Jan17

Grandchildren files and count

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

2024Jan11

ANStringListRead_JSON

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

2024Jan9

CutString9

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

2024Jan7

CutString7

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

2024Jan1

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

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

ANStr2Range

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

2022Nov11

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

1 2 3 ...6 7