Search results 202

Sorted from new to old.

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

Jul26

ANStr_Add10IfNotBlank_NorNA

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

Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Jul18

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

Jul15

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Jul13

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Jul13

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

Jul11

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Jul7

ReturnLongestString_Of2

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

Jul2

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Jun10

CutString97

Cuts part from large string from certain character to certain character with ...

Jun5

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

ANString_Location

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

Apr23

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

CopyFields_FromTo

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

Apr17

1 2 ...12 13