Texts + Strings 169

Texts, strings, convert, replace, encode, parts and concatenations
Sorted from new to old.
Card image
CutString8

Cuts a string from certain character to certain character with option of either ...

Card image
RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Card image
Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

Card image
ANStrSort2

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

Card image
TrimEnters

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

Card image
URLDecode

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

Card image
ReadHTMLTag

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

Card image
JSON-VBA

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

Card image
Sorting Strings

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

Card image
CreateList_Matching

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

Card image
Column2AnString_Unique

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

Card image
IntlIsAlphaCharacter

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

Card image
Remove_Between2Quotes

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

Card image
Capitalize in JS

Convert text to all capital letters

Card image
RandomGUID

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

Card image
ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...