Texts + Strings 168

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

Sorted from new to old.

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

Copy formulas

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

2019Oct3

1 2 ...6 ...10 11