Texts + Strings 184

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

Sorted from new to old.

ANmaReplace_Occurrence

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

2024Jul13

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

ANmaSearch_AposFriends

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

2024Jul11

ANmaSearch_AmpFriends

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

2024Jul7

ReturnLongestString_Of2

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

2024Jul2

CutString97

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

2024Jun5

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

2024May27

ANString_Location

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

2024Apr23

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

1 2 3 ...11 12