Search results 54

Sorted from new to old.

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

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

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

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

FoldersIn5

Creates list of subfolders and subfolders of each down to 5 levels Folder ...

2018Aug8

1 2 3 4