Texts + Strings 176

Texts, strings, convert, replace, encode, parts and concatenations

Sorted from new to old.

ANmaCellFormat

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

2024Apr18

ContainerHTMLTag_ReturnBlock

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

2024Apr3

Concatenate_HTMLColumn

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

2024Mar14

FindAncherURL_InHTMLRow

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

2024Mar4

DateDateDate

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

2024Mar3

NumberNumberNumber

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

2024Mar2

HTML_InsideTag_ByIndex

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

2024Feb28

CutString_ReverseFrom

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

2024Feb27

VBInstr_Numeric

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

2024Feb25

CutString11

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

2024Feb24

ANStrSort3

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

2024Feb20

ANmaRemoveNestedTags

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

2024Feb4

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...

2024Feb1

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

2024Jan31

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

1 2 3 ...10 11