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

Card image cap
ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

Card image cap
TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

Card image cap
URLDecode

Decodes a URL encoded string back into the original text. Similar to ...

Card image cap
HTMLTag

Reads string between open and close HTML tag (between <...> and ), pass ...

Card image cap
JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

JSON-VBA.zip

Card image cap
Sorting Strings

This is not a function as much as a note. I needed to force a line to show at ...

Card image cap
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Card image cap
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Card image cap
IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

Card image cap
Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

Card image cap
Capitalize in JS

Convert text to all capital letters

Card image cap
RandomGUID

Creates a random GUID number like ... 879AE395-E026-0A63-EFC1-152038C4400B ...