Texts + Strings 178

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

Sorted from new to old.

JSON-VBA

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

2020Jul30

Sorting Strings

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

2020Jul22

CreateList_Matching

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

2020May13

Column2AnString_Unique

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

2020May6

IntlIsAlphaCharacter

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

2020Mar21

Remove_Between2Quotes

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

2020Mar9

Capitalize in JS

Convert text to all capital letters

2020Feb16

RandomGUID

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

2019Dec18

ShrinkText

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

2019Oct20

Copy formulas

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

2019Oct3

HTMLDecode + HTMLEncode

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

2019Aug9

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

Save to, Read from, Delete registry key

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

2019Jun15

HeadingZeros Remove and Add

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

2019May31

GetWordCount

Counts how many words found inside a string. Using space, tab or enter as ...

2019Mar31

HttpToAnchors

Convert http found inside text into anchers < a >, aka URLlinker, aka ...

2019Mar30

1 2 ...7 ...11 12