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

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 ...

Card image cap
ShrinkText

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

Card image cap
Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

Card image cap
HTMLDecode + HTMLEncode

Decode and encode back a string using HTML Technically found online, but ...

Card image cap
ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output.

Card image cap
Save to, Read from, Delete registry key

Save into registry, read from registry or delete a key. Accessible to only ...

Card image cap
HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...