Texts + Strings 165

Texts, strings, convert, replace, encode, parts and concatenations
Sorted from new to old.
Card image
ANmaSearch_AmpFriends

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

Card image
ReturnLongestString_Of2

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

Card image
CutString97

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

Card image
ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

Card image
ANString_Location

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

Card image
ANmaCellFormat

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

Card image
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Card image
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Card image
FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Card image
DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Card image
NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Card image
HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Card image
CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

Card image
VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Card image
CutString11

Cuts long string from certain character to certain character with option to ...

Card image
ANStrSort3

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