Search results 40

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
CutString9

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

Card image cap
CutString7

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

Card image cap
ANStrFind_AndOrAdd

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

Card image cap
Frequency1

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

Card image cap
HMatchIf_Multi

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

Card image cap
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

Card image cap
IfFoundInList

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

Card image cap
Range2Block

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

Card image cap
ANStr2Range

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

Card image cap
ANmaRemoveDuplicates

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