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

  2. Categories
  3. Texts + Strings
Card image cap
ANmaCellFormat

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

Thu 10AM
Card image cap
ContainerHTMLTag_ReturnBlock

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

Apr3
Card image cap
Concatenate_HTMLColumn

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

Mar14
Card image cap
FindAncherURL_InHTMLRow

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

Mar4
Card image cap
DateDateDate

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

Mar3
Card image cap
NumberNumberNumber

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

Mar2
Card image cap
HTML_InsideTag_ByIndex

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

Feb28
Card image cap
CutString_ReverseFrom

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

Feb27
Card image cap
VBInstr_Numeric

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

Feb25
Card image cap
CutString11

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

Feb24
Card image cap
ANStrSort3

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

Feb20
Card image cap
ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Feb4