Texts + Strings 169

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

Sorted from new to old.

CutString8

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

2021May29

RandomUniqueID_Sheet

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

2021May29

Quarter_to_Words

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

2020Dec17

ANStrSort2

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

2020Sep24

TrimEnters

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

2020Sep19

URLDecode

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

2020Aug21

ReadHTMLTag

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

2020Aug15

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

1 2 ...6 ...10 11