Texts + Strings 169

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

Sorted from new to old.

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

ANma_HTML2DB + ANma_DB2HTML + ...

Convert HTML text into DB-safe string, by converting some characters as below. ...

2019Feb7

Textbox.io textarea editor

An embed text editor for bootstrap Get official latest release from

2019Jan18

Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

2019Jan9

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

FormatPhoneNumber

Formats a given 10 digit number into a nice looking phone number

2019Jan5

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

2019Jan3

pd

Format a number with total number of digits I used it to format a date as ...

2018Dec29

myURLEncode

Does what Server.URLEncode does In case you needed it, not sure when

2018Oct20

ChrW

Insert special characters inside Cell, using ChrW

2018Sep19

1 2 ...7 ...10 11