Texts + Strings 189

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

Sorted from new to old.

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

2024Jul15

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

2024Jul13

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

1 2 3 ...11 12