Texts + Strings 146 Texts, strings, convert, replace, encode, parts and concatenations

Card image cap
ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

Card image cap
ANString_Location

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

Card image cap
ANmaCellFormat

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

Card image cap
ContainerHTMLTag_ReturnBlock

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

Card image cap
Concatenate_HTMLColumn

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

Card image cap
FindAncherURL_InHTMLRow

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

Card image cap
DateDateDate

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

Card image cap
NumberNumberNumber

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

Card image cap
HTML_InsideTag_ByIndex

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

Card image cap
CutString_ReverseFrom

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

Card image cap
VBInstr_Numeric

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

Card image cap
CutString11

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