Search results 78

Sorted from new to old.

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

Aug21

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

Aug11

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

Aug7

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Jul30

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Jul24

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

Jul2

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Feb20

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

1 2 3 4 5