Search results 59

  2. Search results
  3. ANString
Sorted from new to old.
Card image
RangeValues

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

2024Jan25
Card image
ConcatenateStrings_AmongString

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

2024Jan17
Card image
MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

2024Jan13
Card image
Grandchildren files and count

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

2024Jan11
Card image
ANStringListRead_JSON

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

2024Jan9
Card image
CutString9

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

2024Jan7
Card image
CutString7

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

2024Jan1
Card image
ANStrFind_AndOrAdd

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

2023Dec19
Card image
MathInsideANString

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

2023Nov20
Card image
ReplaceStrings

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

2023Nov11
Card image
Range2Block

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

2023Mar6
Card image
ANStr2Range

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

2022Nov11
Card image
Range2ANStr

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

2022Jul19
Card image
CreateUniqueList

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

2022Apr26
Card image
ANStrSort2

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

2020Sep24
Card image
CreateList_Matching

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

2020May13
1234